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

From Tom Lane
Subject Re: BUG #4779: LIMIT/OFFSET behavior change (possibly related to Top-n)
Date
Msg-id 24218.1240583290@sss.pgh.pa.us
Whole thread Raw
In response to BUG #4779: LIMIT/OFFSET behavior change (possibly related to Top-n)  ("Thomas S. Chin" <thom@genx.net>)
Responses Re: BUG #4779: LIMIT/OFFSET behavior change (possibly related to Top-n)  ("Thomas S. Chin" <thom@genx.net>)
List pgsql-bugs
"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

pgsql-bugs by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: libpq 8.4 beta1: $PGHOST complains about missing root.crt
Next
From: Kevin Field
Date:
Subject: Re: BUG #4763: postgres service unstable, even during install