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/