Postgres Pro
Downloads
Home   >   mailing lists

OID order = INSERT order? - Mailing list pgsql-general

From Justin Hawkins
Subject OID order = INSERT order?
Date
Msg-id 87hegubt0a.fsf@weasel.internode.com.au
Whole thread Raw
Responses 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>)
List pgsql-general
Tree view 
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?

This is happening inside a transaction, if it matters.

        - Justin

--
Justin Hawkins
Internode Professional Access

pgsql-general by date:

Previous
From: Alex Sandini
Date:
Subject: again, pgplsql and parameters question
Next
From: Alex Sandini
Date:
Subject: Re: pgplsql and parameters question