Re: Re: [SQL] oracle rownum equivalent? - Mailing list pgsql-general

From Cary O'Brien
Subject Re: Re: [SQL] oracle rownum equivalent?
Date
Msg-id 200006072247.SAA03722@saltmine.radix.net
Whole thread Raw
In response to Re: [SQL] oracle rownum equivalent?  (mikeo <mikeo@spectrumtelecorp.com>)
Responses Re: Re: [SQL] oracle rownum equivalent?  (mikeo <mikeo@spectrumtelecorp.com>)
List pgsql-general
> 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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Dump
Next
From: Tom Lane
Date:
Subject: Re: plpgsql question...