Re: Obtaining a limited number of records from a long query

--As of May 25, 2009 2:32:14 PM +0100, Oliveiros Cristina is alleged to
have said:

> Is there any way to force a query to return just a few records?
>
> For ex, returning just the first ten rows from a long ORDER BY query ?
>
> And then, eventually, obtaining the remaining records at a later time, or
> in background?
>
> Thanks in advance for your help,

--As for the rest, it is mine.

Depending on what you want, either LIMIT and OFFSET or a cursor will help
you.

<http://www.postgresql.org/docs/8.3/interactive/queries-limit.html>
<http://www.postgresql.org/docs/8.3/interactive/sql-declare.html>

Daniel T. Staal

---------------------------------------------------------------
This email copyright the author. Unless otherwise noted, you
are expressly allowed to retransmit, quote, or otherwise use
the contents for non-commercial purposes. This copyright will
expire 5 years after the author's death, or in 30 years,
whichever is longer, unless such a period is in excess of
local copyright law.
---------------------------------------------------------------