--
-- // This code comes from http://code.calum.org/
-- Name: get_days_by_day(date, date, integer); Type: FUNCTION; Schema: public; Owner: calum
--

CREATE FUNCTION get_days_by_day(date, date, integer) RETURNS SETOF date
    AS $_$declare

r RECORD;

begin
for r in SELECT ($1 + s.t) AS dates FROM generate_series(0,($2 - $1)) AS s(t) WHERE
                     EXTRACT('dow' FROM ($1 + s.t)) = $3 LOOP
return next r;
end loop;
return;
end$_$
    LANGUAGE plpgsql;