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@svana.org> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to > litigate.
signature.asc
Description: Digital signature
