On Tue, 2008-03-25 at 11:47 -0400, Tom Lane wrote: > Simon Riggs <[EMAIL PROTECTED]> writes: > > On Tue, 2008-03-25 at 10:45 -0400, Bruce Momjian wrote: > >> Where does this FETCH appear in a SELECT? > > > It's supposed to go *after* the OFFSET clause in a query, but making it > > a simple synonym for LIMIT seems most sensible. > > Huh? OFFSET isn't in standard SQL either.
Tis now. > Are you sure you're not > confusing FETCH-from-a-cursor with SELECT? Quite sure. -- Simon Riggs 2ndQuadrant http://www.2ndQuadrant.com PostgreSQL UK 2008 Conference: http://www.postgresql.org.uk -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers