Robert Haas <robertmh...@gmail.com> writes:
> On Tue, Aug 18, 2015 at 11:23 PM, Tom Lane <t...@sss.pgh.pa.us> wrote:
>> More generally, what would you hope to accomplish with such a construct
>> that wouldn't be better done by writing the cursor's underlying query
>> directly in the WITH clause?

> Maybe I'm stupid today, but it seems like the obvious use case would
> be fetching some but not all rows from the cursor?

And how many rows would that be?  As I said, the proposed syntax leaves
it completely unclear how many rows get fetched or what the ending cursor
position is; but especially so if you want the answer to be something
other than "all/the end".

                        regards, tom lane


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

Reply via email to