Re: Does Postgresql have a similar pseudo-column "ROWNUM" as Oracle? - Mailing list pgsql-sql

From Andrew Sullivan
Subject Re: Does Postgresql have a similar pseudo-column "ROWNUM" as Oracle?
Date
Msg-id 20050517170636.GC12405@phlogiston.dyndns.org
Whole thread Raw
In response to Does Postgresql have a similar pseudo-column "ROWNUM" as Oracle?  (<Dennis.Jiang@thomson.com>)
Responses Re: Does Postgresql have a similar pseudo-column "ROWNUM" as  (Alain <alainm@pobox.com>)
Re: Changed to: how to solve the get next 100 records problem  (PFC <lists@boutiquenumerique.com>)
List 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 by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Does Postgresql have a similar pseudo-column "ROWNUM" as
Next
From: Bruno Wolff III
Date:
Subject: Re: Does Postgresql have a similar pseudo-column "ROWNUM" as Oracle?