Robert Haas <robertmhaas@gmail.com> writes:
> On Tue, Aug 18, 2015 at 11:23 PM, Tom Lane <tgl@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