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

Поиск

Список

Период

Сортировка

От	Andrew Sullivan
Тема	Re: Does Postgresql have a similar pseudo-column "ROWNUM" as Oracle?
Дата	17 мая 2005 г. 14:06:56
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 по дате отправления:

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

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