FETCH in subqueries or CTEs - Mailing list pgsql-general

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