[GENERAL] Sorting, when values are equal....

2004-10-25 Thread Net Virtual Mailing Lists
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

Re: [GENERAL] Sorting, when values are equal....

2004-10-25 Thread Martijn van Oosterhout
On Mon, Oct 25, 2004 at 04:45:15AM -0700, Net Virtual Mailing Lists wrote: 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

Re: [GENERAL] Sorting, when values are equal....

2004-10-25 Thread Peter Eisentraut
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