| From: | "Oliveiros Cristina" <oliveiros(dot)cristina(at)marktest(dot)pt> |
|---|---|
| To: | <pgsql-sql(at)postgresql(dot)org> |
| Cc: | <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Obtaining a limited number of records from a long query |
| Date: | 2009-05-25 13:32:14 |
| Message-ID: | 020201c9dd3d$372c3f40$ec5a3d0a@marktestcr.marktest.pt |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Luiz Eduardo Cantanhede Neri | 2009-05-25 13:42:24 | Re: Obtaining a limited number of records from a long query |
| Previous Message | Luiz Eduardo Cantanhede Neri | 2009-05-25 13:15:42 | extract and interval |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Luiz Eduardo Cantanhede Neri | 2009-05-25 13:42:24 | Re: Obtaining a limited number of records from a long query |
| Previous Message | Erik Jones | 2009-05-22 21:05:32 | Re: left join where not null vs. inner join |