Re: return records in DB load order?? - Mailing list pgsql-general

From Lincoln Yeoh
Subject Re: return records in DB load order??
Date
Msg-id 5.2.1.1.1.20030614105439.02d95b50@mbox.jaring.my
Whole thread Raw
In response to return records in DB load order??  ("Maksim Likharev" <mlikharev@aurigin.com>)
Responses Re: return records in DB load order??  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-general
At 12:35 PM 6/13/2003 -0700, Maksim Likharev wrote:

>Hi,
>if I'd like to return records in DB load order, will it be enough to say
>
>
>SELECT .....
>ORDER BY oid?
>
>basically I assume that lowest oid will be for early records?

How about using the "serial" type instead?

OID is a bit too close to postgresql internals. Unless you are really "very
good friends" with Postgresql I suggest you don't use it if possible.

Link.


pgsql-general by date:

Previous
From: weigelt@metux.de
Date:
Subject: Re: trigger or function?
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] SAP and MySQL ... [and Benchmark]