Thread: FETCH FIRST
View Single Post

   
  #2 (permalink)  
Old 04-15-2008, 11:48 PM
Bruce Momjian
 
Posts: n/a
Default Re: FETCH FIRST

Simon Riggs wrote:
> 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


Where does this FETCH appear in a SELECT?

--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply With Quote