Re: Re: [SQL] oracle rownum equivalent?

Cary O'Brien <cobrien@radix.net>

From: "Cary O'Brien" <cobrien@Radix.Net>
To: pgsql-general@hub.org
Date: 2000-06-07T22:47:39Z
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