On Fri, Aug 25, 2006 at 07:57:52AM +0200, Rafal Pietrak wrote:
> Hi all,
>
> There is this functions like 'current_date', 'current_database', etc.
> yielding a row of data without any table to source rows from. Like:
> dev=# SELECT current_date;
> date
> ------------
> 2006-08-25
> (1 row)
Not all functions require an input, as you see, so then you don't need
a table to get an output.
For the rest of your question, see generate_series();
http://www.postgresql.org/docs/8.1/static/functions-srf.html
Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.