| From: | Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it> |
|---|---|
| To: | <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Obtaining a limited number of records from a long query |
| Date: | 2009-05-25 14:13:47 |
| Message-ID: | 20090525161347.166789ac@dawn.webthatworks.it |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice pgsql-sql |
On Mon, 25 May 2009 14:55:54 +0100
"Oliveiros Cristina" <oliveiros(dot)cristina(at)marktest(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daniel Staal | 2009-05-25 14:15:50 | Re: Obtaining a limited number of records from a long query |
| Previous Message | Oliveiros Cristina | 2009-05-25 13:55:54 | Re: Obtaining a limited number of records from a long query |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daniel Staal | 2009-05-25 14:15:50 | Re: Obtaining a limited number of records from a long query |
| Previous Message | Oliveiros Cristina | 2009-05-25 13:55:54 | Re: Obtaining a limited number of records from a long query |