From: | dustin sallings <dustin(at)spy(dot)net> |
---|---|
To: | Fabrice Scemama <Fabrice(dot)Scemama(at)GESNET(dot)NET> |
Cc: | pgsql-general(at)hub(dot)org |
Subject: | Re: [GENERAL] LIMITS in SELECTs |
Date: | 1999-01-09 19:09:39 |
Message-ID: | Pine.NEB.4.02.9901091109030.19316-100000@dhcp-199.west.spy.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Sat, 9 Jan 1999, Fabrice Scemama wrote:
// Is there a way to select only a range of rows from a table, using a command
// like:
//
// SELECT * FROM table WHERE where_statement LIMIT 50,100;
That doesn't make sense in a relational database by itself since
it's not guaranteed to return any particular dataset in any particular
order. What you want is a cursor.
// I've tried, and then read the doc, but found no information so far.
//
// Thanks in advance.
//
//
//
// Fabrice Scemama
//
//
--
Principle Member Technical Staff, beyond.com The world is watching America,
pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin(at)spy(dot)net>
| Key fingerprint = 87 02 57 08 02 D0 DA D6 C8 0F 3E 65 51 98 D8 BE
L______________________________________________ and America is watching TV. __
From | Date | Subject | |
---|---|---|---|
Next Message | Todd Graham Lewis | 1999-01-09 19:11:04 | Re: [HACKERS] RE: [GENERAL] Benchmarking PGSQL against Microsoft SQL 7 |
Previous Message | Thomas G. Lockhart | 1999-01-09 18:52:11 | Re: [HACKERS] RE: [GENERAL] Benchmarking PGSQL against Microsoft SQL 7 |