Postgres Pro
Downloads
Home   >   mailing lists

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

From Luiz Eduardo Cantanhede Neri
Subject Re: Obtaining a limited number of records from a long query
Date
Msg-id 252e1f290905250642w66c6b962k248624b5327be043@mail.gmail.com
Whole thread Raw
In response to Obtaining a limited number of records from a long query  ("Oliveiros Cristina" <oliveiros.cristina@marktest.pt>)
List pgsql-novice
Tree view
Visit http://www.sqlzoo.net/howto/source/z.dir/tip915069/postgres and u'll get ur awnser and others like from 11th and on.

For now you may try SELECT * FROM cia LIMIT 10

On Mon, May 25, 2009 at 10:32 AM, Oliveiros Cristina <oliveiros.cristina@marktest.pt> wrote:
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

pgsql-novice by date:

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