--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.
---------------------------------------------------------------