Re: Does Postgresql have a similar pseudo-column "ROWNUM" as Oracle?

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: Does Postgresql have a similar pseudo-column "ROWNUM" as Oracle?
Дата
Msg-id 20050517170636.GC12405@phlogiston.dyndns.org
обсуждение исходный текст
Ответ на Does Postgresql have a similar pseudo-column "ROWNUM" as Oracle?  (<Dennis.Jiang@thomson.com>)
Ответы Re: Does Postgresql have a similar pseudo-column "ROWNUM" as
Re: Changed to: how to solve the get next 100 records problem
Список pgsql-sql
Дерево обсуждения 
On Thu, May 12, 2005 at 01:07:00PM -0600, Dennis.Jiang@thomson.com wrote:
> 
> Does Postgresql have a similar pseudo-column "ROWNUM" as Oracle? If
> so, we can write the following query:

No.  What is the purpose of your query?  You could use ORDER BY and
LIMIT..OFFSET to do what you want. I think.

A

-- 
Andrew Sullivan  | ajs@crankycanuck.ca
The whole tendency of modern prose is away from concreteness.    --George Orwell

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

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: Does Postgresql have a similar pseudo-column "ROWNUM" as
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: Does Postgresql have a similar pseudo-column "ROWNUM" as Oracle?