Re: OID order = INSERT order?

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.