Re: Re: [SQL] oracle rownum equivalent?

From: "Cary O'Brien" <cobrien(at)Radix(dot)Net>
To: pgsql-general(at)hub(dot)org
Subject: Re: Re: [SQL] oracle rownum equivalent?
Date: 2000-06-07 22:47:39
Message-ID: 200006072247.SAA03722@saltmine.radix.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql


> thanks for the response. oid is equivalent to oracle rowid.

I think there is a fundamentel difference between oid and rownum.
Oid is just a serial number. Rownum is a long string that tells
oracle where exactly the row is. So *I think* rownum can be
used for fast lookups, where oid, unless indexed, can't.

Other than that they are the same pretty much.

-- cary

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John Daniels 2000-06-07 23:02:37 FreeBSD PostgreSQL7 port and v7.0.2
Previous Message Tom Lane 2000-06-07 22:45:31 Re: Dump

Browse pgsql-sql by date

  From Date Subject
Next Message Joseph Shraibman 2000-06-07 23:52:16 counting distinct values
Previous Message Bernie Huang 2000-06-07 18:20:19 Please ignore [PSQL and PHP]