Sorting, when values are equal.... - Mailing list pgsql-general

From Net Virtual Mailing Lists
Subject Sorting, when values are equal....
Date
Msg-id 20041025114515.29998@mail.net-virtual.com
Whole thread Raw
Responses Re: Sorting, when values are equal....  (Martijn van Oosterhout <kleptog@svana.org>)
Re: Sorting, when values are equal....  (Peter Eisentraut <peter_e@gmx.net>)
List 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




pgsql-general by date:

Previous
From: Jeff Davis
Date:
Subject: Re: pqAdmin3
Next
From: "Philippe Lang"
Date:
Subject: Re: FKs and deadlocks