From: Ivan Sergio Borgonovo <mail@webthatworks.it>
To: pgsql-sql@postgresql.org
Subject: Re: Obtaining a limited number of records from a long query
Date: Mon, 25 May 2009 16:13:47 +0200
Message-ID: <20090525161347.166789ac@dawn.webthatworks.it> (raw)
In-Reply-To: <025501c9dd40$86155440$ec5a3d0a@marktestcr.marktest.pt>
References: <020201c9dd3d$372c3f40$ec5a3d0a@marktestcr.marktest.pt>
<4A1AA0FA.1070507@networkmail.eu>
<025501c9dd40$86155440$ec5a3d0a@marktestcr.marktest.pt>
On Mon, 25 May 2009 14:55:54 +0100
"Oliveiros Cristina" <oliveiros.cristina@marktest.pt> wrote:
>
>
> Thanks a million, Andy.
>
> It's precisely what I needed, Indeed!
Beware: unless you specify an ORDER BY (and you expect no other
record is inserted between one query and the other... or you just
don't care) you may incur in unexpected results.
A query without an order by is not granted to return the result in
the same order.
If you can (same session) you may use cursors.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mail@webthatworks.it
Subject: Re: Obtaining a limited number of records from a long query
In-Reply-To: <20090525161347.166789ac@dawn.webthatworks.it>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox