Home > mailing lists

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

From	Oliveiros Cristina
Subject	Obtaining a limited number of records from a long query
Date	May 25, 2009 13:34:14
Msg-id	020201c9dd3d$372c3f40$ec5a3d0a@marktestcr.marktest.pt Whole thread Raw
Responses	Re: Obtaining a limited number of records from a long query (Andy Shellam <andy-lists@networkmail.eu>)
List	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: Erik Jones
Date: 22 May 2009, 21:05:37
Subject: Re: left join where not null vs. inner join

From: Andy Shellam
Date: 25 May 2009, 13:46:41
Subject: Re: Obtaining a limited number of records from a long query