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" <thom@genx.net> 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