From: | Zeugswetter Andreas DBT <Andreas(dot)Zeugswetter(at)telecom(dot)at> |
---|---|
To: | "'pgsql-hackers(at)hub(dot)org'" <pgsql-hackers(at)hub(dot)org> |
Subject: | Re: [QUESTIONS] Arrays (inserting and removing) |
Date: | 1998-01-16 08:34:29 |
Message-ID: | 219F68D65015D011A8E000006F8590C6010A5199@sdexcsrv1.sd.spardat.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
>> 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
From | Date | Subject | |
---|---|---|---|
Next Message | bas aerts | 1998-01-16 09:29:07 | (no subject) |
Previous Message | Zeugswetter Andreas DBT | 1998-01-16 08:23:53 | Nope: Cannot build recent snapshot |