OID order = INSERT order?

From: Justin Hawkins <justin(at)internode(dot)com(dot)au>
To: pgsql-general(at)postgresql(dot)org
Subject: OID order = INSERT order?
Date: 2002-09-13 01:03:33
Message-ID: 87hegubt0a.fsf@weasel.internode.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jean-Christian Imbeault 2002-09-13 02:03:01 What characters need to be quoted?
Previous Message James Orr 2002-09-12 22:10:01 Re: [SQL] Latitude / Longitude