Quang Thoi wrote > Thanks Steve! > > Just want to get confirmation that postgres does not use any special rules > > When no sorting order specified. Didn't your testing prove that out sufficiently? I'd be more concerned, though, if you took random congruence between the two results (I.e. If they both happened to returned in the same order) to mean that you could trust in some order the you did not specify as being important. David J. -- View this message in context: http://postgresql.1045698.n5.nabble.com/How-is-sorting-work-tp5805636p5805641.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.