Robert James <srobertjames@xxxxxxxxx> writes: > On 11/7/11, Merlin Moncure <mmoncure@xxxxxxxxx> wrote: >> On Mon, Nov 7, 2011 at 3:47 PM, Robert James <srobertjames@xxxxxxxxx> wrote: >>> I've been using a query on Postgres 8.4 with a negative OFFSET, which >>> works fine: >>> SELECT DISTINCT s.* FROM s WHERE ... ORDER BY s.bday ASC, s.name >>> ASC LIMIT 15 OFFSET -15 >> the original behavior was undefined. > What do it do in reality? I'm debugging a legacy app which used it. It used to treat negative offsets/limits as zero. http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=bfce56eea45b1369b7bb2150a150d1ac109f5073 > Also: Is there any reference in the docs to this? I wasn't able to find this. The 8.4 release notes mention * Disallow negative LIMIT or OFFSET values, rather than treating them as zero (Simon) I'm pretty sure this changed in 8.4, not since then. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
