Re: [GENERAL] LIMITS in SELECTs

Поиск
Список
Период
Сортировка
От dustin sallings
Тема Re: [GENERAL] LIMITS in SELECTs
Дата
Msg-id Pine.NEB.4.02.9901091109030.19316-100000@dhcp-199.west.spy.net
обсуждение исходный текст
Ответ на LIMITS in SELECTs  (Fabrice Scemama <Fabrice.Scemama@GESNET.NET>)
Список 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@spy.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. __


В списке pgsql-general по дате отправления:

Предыдущее
От: "Richard Vaughan"
Дата:
Сообщение: Databases on Linux
Следующее
От: Michael Wright
Дата:
Сообщение: Please help with a Solaris 2.6 build error