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

[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? Like:
        dev=# SELECT current_date where date between now and yesterday;
            date    
        ------------
         2006-08-24
         2006-08-25
        (2 rows)
(of cource this is 'cooked' example, as I haven't figured out how to
achieve this).
Or:
        dev=# SELECT * where a::numeric between 1 and 3;
            a    
        ------------
         1
         3
         2
        (3 rows)

-- 
-R

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org