Re: generating date sequences - Mailing list pgsql-sql

Hi!

>> Is there a simple way to generate sequences of dates like the following?
> Sure:
> test=# select '2008-07-03'::date + s * '1day'::interval from
> generate_Series(1,10) s;


Thanks! Thats what I was searching for.

You saved my day from manually adding missing dates in a huge excel sheet!

So thank you again!

P. Scharrenberg