Sam Mason <s...@samason.me.uk> wrote: >> suppose I thought that PostgreSQL would benefit greatly from >> a "generate_series(DATE, DATE[, INT]) RETURNS DATE" function
> 8.4 has a generate_series(timestamp,timestamp,interval) which would seem > to be a bit more flexible than you want. Yes, I know :-). But as "generate_series(A, B, C)" can also be written as "A + generate_series(0, (C - B) / C) * C" (or something "flexible" like that :-)), a "generate_series(DATE, DATE)" would inter alia get rid off the need to cast the result from TIMESTAMP to DATE and to explicitly specify "'1 day'". Just a small, trivial enhance- ment for a popular use case :-). Tim -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
