Postgres Pro
Downloads
Home   >   mailing lists

Re: Obtaining a limited number of records from a long query - Mailing list pgsql-sql

From Ivan Sergio Borgonovo
Subject Re: Obtaining a limited number of records from a long query
Date
Msg-id 20090525161347.166789ac@dawn.webthatworks.it
Whole thread Raw
In response to Re: Obtaining a limited number of records from a long query  ("Oliveiros Cristina" <oliveiros.cristina@marktest.pt>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: "Oliveiros Cristina"
Date:
Subject: Re: Obtaining a limited number of records from a long query
Next
From: "Oliveiros Cristina"
Date:
Subject: Re: Obtaining a limited number of records from a long query