Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 37DE763564B; Mon, 25 May 2009 10:34:12 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 70151-01-6; Mon, 25 May 2009 10:34:10 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from jupiter.marktest.pt (delta.marktest.pt [80.251.174.116]) by mail.postgresql.org (Postfix) with ESMTP id 401E5634986; Mon, 25 May 2009 10:32:18 -0300 (ADT) Received: from suite (suite.marktest.pt [10.61.90.236]) by jupiter.marktest.pt with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2653.13) id K0H2PVF0; Mon, 25 May 2009 14:32:14 +0100 Message-ID: <020201c9dd3d$372c3f40$ec5a3d0a@marktestcr.marktest.pt> From: "Oliveiros Cristina" To: Cc: Subject: Obtaining a limited number of records from a long query Date: Mon, 25 May 2009 14:32:14 +0100 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_01FF_01C9DD45.98E00570" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200905/84 X-Sequence-Number: 21444 This is a multi-part message in MIME format. ------=_NextPart_000_01FF_01C9DD45.98E00570 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Dear List, 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, Best, Oliveiros ------=_NextPart_000_01FF_01C9DD45.98E00570 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Dear List,
 
Is there any way to force a query to = return just a=20 few records?
 
For ex, returning just the first ten = rows from a=20 long ORDER BY query ?
 
And then, eventually, obtaining the = remaining=20 records at a later time, or in background?
 
Thanks in advance for your = help,
 
Best,
Oliveiros
------=_NextPart_000_01FF_01C9DD45.98E00570--