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