Status of OIDs was: Re: select first occurrence of a table
От
Benjamin Scherrey
Тема
Status of OIDs was: Re: select first occurrence of a table
Дата
Msg-id
07FQOLI73YV073Y4ZJEPN3YDUQ7.3eb2d473@bonzoii
Ответ на
Re: select first occurrence of a table (Erik Ronström)
Список
Дерево обсуждения
select first occurrence of a table "Johnson, Shaunn" <SJohnson6@bcbsm.com>
Re: select first occurrence of a table Erik Ronström <kvarken@yahoo.com>
Re: select first occurrence of a table Erik Ronström <kvarken@yahoo.com>
Status of OIDs was: Re: select first occurrence of a table Benjamin Scherrey <scherrey@proteus-tech.com>
Re: Status of OIDs was: Re: select first occurrence of a table Alvaro Herrera <alvherre@dcc.uchile.cl>
Re: Status of OIDs was: Re: select first occurrence of a table Benjamin Scherrey <scherrey@proteus-tech.com>
Re: select first occurrence of a table Tom Lane <tgl@sss.pgh.pa.us>
Re: select first occurrence of a table Dennis Gearon <gearond@cvc.net>
Re: select first occurrence of a table "scott.marlowe" <scott.marlowe@ihs.com>
Speaking of OIDs... I noticed that the talk is that these are being deprecated which, from my non relationally purist/pro-object perspective, kinda disappointed me although I can guess at some possible reasons. Is there some docs or a thread that someone can point me to that covers this issue as I expect its been hashed over in depth already. I'd appreciate any information about the justification and expected impact of this direction that Postgres is taking. many thanx, Ben Scherrey 5/2/2003 1:33:08 PM, Erik Ronström wrote: >If the table has OIDs (which is the default), you can use the OID as a >unique identifier for a row. But then you'll have to perform two >queries: > >SELECT oid FROM table WHERE ... LIMIT 1; > >UPDATE table SET ... WHERE oid = ...; > >Erik
В списке pgsql-general по дате отправления
От: Karsten Hilbert
Дата: