Re: Get a row by it's number

Boszormenyi Laszlo wrote:
>
> Hello!
>
>  Is there any way to execute a select, and get only a specified row (let's
> say the third one)?

SELECT ..... LIMIT 1,3

From the documentation... postgresql-doc/html/user/sql-select.htm

 :-)

Cheers,
                    Andrew.
--
_____________________________________________________________________
            Andrew McMillan, e-mail: Andrew@cat-it.co.nz
Catalyst IT Ltd, PO Box 10-225, Level 22, 105 The Terrace, Wellington
Me: +64 (21) 635 694, Fax: +64 (4) 499 5596, Office: +64 (4) 499 2267