Behavior of negative OFFSET - Mailing list pgsql-general

From Robert James
Subject Behavior of negative OFFSET
Date
Msg-id CAGYyBggx9_ajO3L5Lmr-6rNK238J+zZdxL=QFEarjTG17cRTtg@mail.gmail.com
Whole thread Raw
Responses Re: Behavior of negative OFFSET  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-general
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

When I run the same query on Postgres 9.1, I get an error:
   ERROR: OFFSET must not be negative


Question:
1. Was this changed in a version of Postgres? Is this configurable?
2. How do I get the original behavior of negative offsets?

pgsql-general by date:

Previous
From: pasman pasmański
Date:
Subject: Www emulator
Next
From: Merlin Moncure
Date:
Subject: Re: Behavior of negative OFFSET