Re: BUG #4779: LIMIT/OFFSET behavior change (possibly related to Top-n)

Ah, okay, found the documentation mentioning this (LIMIT).  I was 
looking in the wrong place (ORDER BY clause).

Thanks again for the help.

Tom Lane wrote:
> "Thomas S. Chin"  writes:
>> I noticed that the behavior of queries that involve LIMIT/OFFSET no longer
>> return results consistent with the ordering of the same query without
>> LIMIT/OFFSET:
> 
> No, this is not considered a bug; no such behavior has ever been
> promised.  Read the fine manual.
> 
> (Your actual problem is that the sort ordering is underspecified, which
> means you'll get varying results anyway.)
> 
> 			regards, tom lane