Re: create a 'range' of dates/numbers? - Mailing list pgsql-general

A. Kretschmer schreef:
> In response to Erwin Moller :
>
>> Hi,
>>
>> Is it possible to create a range of dates or numbers inside a query
>> without wrining in procedural language?
>> I am looking for something that creates some kind of 'temp table' inside
>> a query.
>> eg:
>>
>
> generate_Series():
>
> test=# select * from generate_Series(1,5);
>  generate_series
> -----------------
>                1
>                2
>                3
>                4
>                5
> (5 rows)
>
> test=*# select current_date + s * '1day'::interval  from
> generate_Series(1,5)s;
>       ?column?
> ---------------------
>  2008-12-20 00:00:00
>  2008-12-21 00:00:00
>  2008-12-22 00:00:00
>  2008-12-23 00:00:00
>  2008-12-24 00:00:00
> (5 rows)
>
>
> Andreas
>
Wow, you ARE fast. :-)

Thanks a lot all, excactly what I was looking for!

Regards,
Erwin Moller