Re: return records in DB load order??

From: "Maksim Likharev" <mlikharev(at)aurigin(dot)com>
To: <gearond(at)cvc(dot)net>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: return records in DB load order??
Date: 2003-06-13 20:33:08
Message-ID: 56510AAEF435D240958D1CE8C6B1770A014A0C78@mailc03.aurigin.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is isn't suppose to be unique?

-----Original Message-----
From: Dennis Gearon [mailto:gearond(at)cvc(dot)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(at)postgresql(dot)org so that
your
> message can get through to the mailing list cleanly
>

Browse pgsql-general by date

  From Date Subject
Next Message scott.marlowe 2003-06-13 20:35:11 Re: Question: script to start DB on server reboot
Previous Message Erik Price 2003-06-13 20:26:47 using sequences