Sorting, when values are equal....

From: "Net Virtual Mailing Lists" <mailinglists(at)net-virtual(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Sorting, when values are equal....
Date: 2004-10-25 11:45:15
Message-ID: 20041025114515.29998@mail.net-virtual.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

If I do something like:

SELECT * FROM sometable ORDER BY somerow DESC LIMIT 1 OFFSET 2;

.. and there are multiple rows in sometable where somerow is identical,
am I assured that the values will always come back in the same order?
..... Or do I need to ensure that a second sort (such as the oid?) is used?

Thanks!

- Greg

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Philippe Lang 2004-10-25 12:35:13 Re: FKs and deadlocks
Previous Message Jeff Davis 2004-10-25 05:01:09 Re: pqAdmin3