Skip site navigation (1) Skip section navigation (2)

FETCH FIRST

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: FETCH FIRST
Date: 2008-03-25 14:45:03
Message-ID: 1206456303.4285.926.camel@ebony.site (view raw or flat)
Thread:
Lists: pgsql-hackers
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


Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2008-03-25 14:45:51
Subject: Re: FETCH FIRST
Previous:From: Simon RiggsDate: 2008-03-25 14:44:58
Subject: TRUNCATE TABLE with IDENTITY

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group