Re: FETCH FIRST

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: Bruce Momjian <bruce(at)momjian(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: FETCH FIRST
Date: 2008-03-25 15:47:04
Message-ID: 21513.1206460024@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Simon Riggs <simon(at)2ndquadrant(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2008-03-25 15:48:48 Re: TRUNCATE TABLE with IDENTITY
Previous Message Martijn van Oosterhout 2008-03-25 15:43:07 Re: HP-UX 11.11 PostgreSQL 8.3.1 - psql core dumps - Unresolved symbol: tgetent