Re: return records in DB load order??

From: Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my>
To: "Maksim Likharev" <mlikharev(at)aurigin(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: return records in DB load order??
Date: 2003-06-14 03:00:43
Message-ID: 5.2.1.1.1.20030614105439.02d95b50@mbox.jaring.my
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Robert Treat 2003-06-14 03:54:22 Re: [HACKERS] SAP and MySQL ... [and Benchmark]
Previous Message weigelt 2003-06-14 01:15:39 Re: trigger or function?