Re: More WITH

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