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" <t...@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
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
