Re: [GENERAL] multimpe records output from a 'no-table' source

2006-08-25 Thread Rafal Pietrak
On Fri, 2006-08-25 at 08:02 +0200, Martijn van Oosterhout wrote: > For the rest of your question, see generate_series(); > > http://www.postgresql.org/docs/8.1/static/functions-srf.html Thenx, That's exactly what I've needed! -- -R ---(end of broadcast)-

Re: [GENERAL] multimpe records output from a 'no-table' source

2006-08-24 Thread Martijn van Oosterhout
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 > >

[GENERAL] multimpe records output from a 'no-table' source

2006-08-24 Thread Rafal Pietrak
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) Is there a way to get multiple rows? L