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. > to kinda sorta get it, > create function oldoffset(int) returns int as > $$ > select case when $1 < 0 then 0 else $1 end; > $$ language sql immutable; > > select v from generate_series(1,15) v limit 15 offset oldoffset(-15); > That sounds like if OFFSET was negative, it would be simply ignored. Is that correct? When was the behavior of OFFSET changed? Also: Is there any reference in the docs to this? I wasn't able to find this. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
