Postgres Pro
Downloads
Home   >   mailing lists

FETCH FIRST - Mailing list pgsql-hackers

From Simon Riggs
Subject FETCH FIRST
Date
Msg-id 1206456303.4285.926.camel@ebony.site
Whole thread Raw
Responses Re: FETCH FIRST  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
Tree view 
SQL200n specifies a new command similar to our LIMIT

FETCH { FIRST | NEXT } n { ROW | ROWS } ONLY

and also that the OFFSET command can have an optional suffix

{ ROW | ROWS }

Seems like a % project for the TODO list

--  Simon Riggs 2ndQuadrant  http://www.2ndQuadrant.com 
 PostgreSQL UK 2008 Conference: http://www.postgresql.org.uk

pgsql-hackers by date:

Previous
From: Decibel!
Date:
Subject: Re: writing a MIN(RECORD) aggregate
Next
From: Simon Riggs
Date:
Subject: TRUNCATE TABLE with IDENTITY