Re: Sorting, when values are equal....

Net Virtual Mailing Lists wrote:
> 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? .....

No.

> Or do I need to ensure that a second sort (such as
> the oid?) is used?

Yes.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/