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

From: jdassen(at)cistron(dot)nl (J(dot)H(dot)M(dot) Dassen (Ray))
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Newbie ex-Oracle person's question: Oracle ROWID = PSQL OID, Orac le ROWNUM = PSQL ???
Date: 2001-05-11 15:29:39
Message-ID: slrn9fo1b3.iuj.jdassen@odin.cistron-office.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Robert Beer <Robert(dot)Beer(at)Callserve(dot)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.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Jeff MacDonald 2001-05-11 16:28:57 Re: execute client application from PL/pgSql
Previous Message Roberto Mello 2001-05-11 15:06:05 Re: [HACKERS] Problems in porting from Oracle to Postgres