FETCH in subqueries or CTEs

[Craig Ringer <ringerc@xxxxxxxxxxxxx>]

Hi all

I've noticed that FETCH doesn't seem to be supported in subqueries or in 
CTEs.

Is there a specific reason for that, beyond "nobody's needed it and 
implemented it"? I'm not complaining at all, merely curious.

A toy example:

    DECLARE somecursor CURSOR FOR SELECT generate_series(1,1000)
    SELECT * FROM ( FETCH ALL FROM somecursor ) x;

produces:

    ERROR:  syntax error at or near "FETCH"
    LINE 1: SELECT * FROM ( FETCH ALL FROM somecursor ) x;
                        ^
Same with a CTE:

     WITH x AS ( FETCH ALL FROM somecursor ) SELECT * FROM x;

ERROR:  syntax error at or near "FETCH"
LINE 1: WITH x AS ( FETCH ALL FROM somecursor ) SELECT * FROM x;

--
Craig Ringer


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general