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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Thomas S(dot) Chin" <thom(at)genx(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4779: LIMIT/OFFSET behavior change (possibly related to Top-n)
Date: 2009-04-24 14:28:10
Message-ID: 24218.1240583290@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Thomas S. Chin" <thom(at)genx(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Thomas S. Chin 2009-04-24 14:34:58 Re: BUG #4779: LIMIT/OFFSET behavior change (possibly related to Top-n)
Previous Message Magnus Hagander 2009-04-24 14:11:10 Re: libpq 8.4 beta1: $PGHOST complains about missing root.crt