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/ ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
