Re: Newbie ex-Oracle person's question: Oracle ROWID = PSQL OID, Orac le ROWNUM = PSQL ??? - Mailing list pgsql-sql

From jdassen@cistron.nl (J.H.M. Dassen (Ray))
Subject Re: Newbie ex-Oracle person's question: Oracle ROWID = PSQL OID, Orac le ROWNUM = PSQL ???
Date
Msg-id slrn9fo1b3.iuj.jdassen@odin.cistron-office.nl
Whole thread Raw
In response to Newbie ex-Oracle person's question: Oracle ROWID = PSQL OID, Orac le ROWNUM = PSQL ???  (Robert Beer <Robert.Beer@Callserve.com>)
List pgsql-sql
Robert Beer <Robert.Beer@Callserve.com> wrote:
> Oracle has a ROWNUM pseudo column that works like this ...
> TEST>select callid, rownum from cs_calls where rownum < 5;

> Is there something like this in PSQL?

SELECT callid FROM cs_calls LIMIT 4;

HTH,
Ray
-- 
Give a man a fire, he's warm for a day.  Set a man on fire, he's warm for
the rest of his life.



pgsql-sql by date:

Previous
From: "Wei Weng"
Date:
Subject: Is this possible?
Next
From: Jeff Eckermann
Date:
Subject: RE: Order by email address by domain ?