Obtaining a limited number of records from a long query

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: Raw Message | Whole Thread | 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

Responses

Browse pgsql-novice by date

  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

Browse pgsql-sql by date

  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