Re: More WITH - Mailing list pgsql-hackers

From Tom Lane
Subject Re: More WITH
Date
Msg-id 29334.1440183194@sss.pgh.pa.us
Whole thread Raw
In response to Re: More WITH  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: More WITH  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> The existing syntax for FETCH already includes a way to specify the
> number of rows you want to fetch, as in this example from the
> documentation:
> FETCH FORWARD 5 FROM liahona;
> Why wouldn't that work here too?

Mm, okay, but you still have the other objections to address.

(And it remains the case that you can do this today with a plpgsql
function, which solves the indeterminate-rowtype problem by nailing
down the rowtype at the function result level.)
        regards, tom lane



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: More WITH
Next
From: Robert Haas
Date:
Subject: Re: More WITH