Re: FETCH FIRST - Mailing list pgsql-hackers

From Tom Lane
Subject Re: FETCH FIRST
Date
Msg-id 21513.1206460024@sss.pgh.pa.us
Whole thread Raw
In response to Re: FETCH FIRST  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: FETCH FIRST
List pgsql-hackers
Simon Riggs <simon@2ndquadrant.com> 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.  Are you sure you're not
confusing FETCH-from-a-cursor with SELECT?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: HP-UX 11.11 PostgreSQL 8.3.1 - psql core dumps - Unresolved symbol: tgetent
Next
From: Tom Lane
Date:
Subject: Re: TRUNCATE TABLE with IDENTITY