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

From Maksim Likharev
Subject Re: return records in DB load order??
Date
Msg-id 56510AAEF435D240958D1CE8C6B1770A014A0C78@mailc03.aurigin.com
Whole thread Raw
In response to return records in DB load order??  ("Maksim Likharev" <mlikharev@aurigin.com>)
List pgsql-general
Is isn't suppose to be unique?

-----Original Message-----
From: Dennis Gearon [mailto:gearond@cvc.net]
Sent: Friday, June 13, 2003 1:30 PM
To: Maksim Likharev
Subject: Re: [GENERAL] return records in DB load order??


unless the OID rolls over, which can and does happen to bigger
databases.

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?
>
> ---------------------------(end of
broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that
your
>       message can get through to the mailing list cleanly
>


pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: Index not being used in MAX function (7.2.3)
Next
From: "Dann Corbit"
Date:
Subject: Re: return records in DB load order??