Re: [QUESTIONS] Arrays (inserting and removing)

Поиск
Список
Период
Сортировка
Искать
От
Zeugswetter Andreas DBT
Тема
Re: [QUESTIONS] Arrays (inserting and removing)
Дата
Msg-id
219F68D65015D011A8E000006F8590C6010A5199@sdexcsrv1.sd.spardat.at
Список
>> 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, from  where ;
>
>	That display minimal data to the browser, and then if someone
>wants more detailed information, I just do:
>
>select * from 
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
В списке pgsql-hackers по дате отправления
От: Zeugswetter Andreas DBT
Дата:
От: bas aerts
Дата:
Сообщение: (no subject)
FAQ