Thread

Re: [QUESTIONS] Arrays (inserting and removing)

Zeugswetter Andreas <andreas.zeugswetter@telecom.at> — 1998-01-16T08:34:29Z

>> 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