Henry Ortega wrote:
(question about set of all days between two dates)
I don't know of a builtin way to do it off the top of my head, but it's a pretty simple function to write:
create function days (start date, finish date) returns setof date as $$
declare curdate date;
begin curdate := start; while (curdate <= finish) loop return next curdate; curdate := curdate + 1; end loop;
return;
end;
$$ language plpgsql;
# select * from days ('2006-02-01', '2006-02-07'); days
------------2006-02-012006-02-022006-02-032006-02-042006-02-052006-02-062006-02-07
(7 rows)