Re: Re: [SQL] oracle rownum equivalent?

"Cary O'Brien" <cobrien(at)Radix(dot)Net> writes:
> What I meant to say, and failed, was that in Oracle, rowid
> "psuedo-column" are hex encoded strings containing the block, row, and
> file where the tuple is stored. So lookup on unindexed rowid *should*
> be fast, although this is not spelled out in my ancient Oracle book.

Oh, in that case it's pretty much like our CTID column. For example:

regression=# select ctid,* from int8_tbl where ctid = '(0,3)';
ctid | q1 | q2
-------+------------------+-----
(0,3) | 4567890123456789 | 123
(1 row)

There is some code in 7.0 that tries to implement this in a fast way,
but I don't know how well it works...

regards, tom lane