Re: OID order = INSERT order?
От
scott.marlowe
Тема
Re: OID order = INSERT order?
Дата
Msg-id
Pine.LNX.4.33.0209160942260.32487-100000@css120.ihs.com
Ответ на
OID order = INSERT order? (Justin Hawkins)
Список
Дерево обсуждения
OID order = INSERT order? Justin Hawkins <justin@internode.com.au>
Re: OID order = INSERT order? Martijn van Oosterhout <kleptog@svana.org>
Re: OID order = INSERT order? Tom Lane <tgl@sss.pgh.pa.us>
Re: OID order = INSERT order? "scott.marlowe" <scott.marlowe@ihs.com>
Re: OID order = INSERT order? elein <elein@norcov.com>
Re: OID order = INSERT order? Tom Lane <tgl@sss.pgh.pa.us>
Re: OID order = INSERT order? Elaine Lindelef <eel@cognitivity.com>
Re: OID order = INSERT order? Roland Roberts <roland@astrofoto.org>
Re: OID order = INSERT order? Adrian von Bidder <avbidder@fortytwo.ch>
On 13 Sep 2002, Justin Hawkins wrote: > > Hi folks, > > I am converting a legacy (DBM file backend) app to SQL. The current > storage scheme utlizes ordered list values on objects. To emulate this > I'm just doing multiple INSERTs on a table. > > I need to make sure they will come back out in the same order, every > time though. > > When I fetch values back from the table, if I 'ORDER BY oid', will I > always get them back in the same order I put them in? If you update a row, it will then have a different OID since postgresql uses MVCC. do it the right way, make a sequence and attach it to the table.
В списке pgsql-general по дате отправления
