>> OIDs are a bastardization of the relational model. If you have to
keep
>> them, then do so, but their use should be SEVERELY discouraged.
>
> Actually, I use them quite extensively...I have several
WWW-based
>search directories that are searched with:
>
>select oid,<fields> from <table> where <search conditions>;
>
> That display minimal data to the browser, and then if someone
>wants more detailed information, I just do:
>
>select * from <table> where oid = '';
>
> Its also great if you mess up the original coding for a table
and
>want to remove 1 of many duplicates that you've accidently let pass
>through :(
Since OID is not a rowid (physical address) it needs an extra index,
that has to be built,
for what you state ROWID will be a lot better (since it don't need an
index)
This is on the TODO (something like add ctid to where clause)
Andreas