Skip site navigation (1) Skip section navigation (2)

Re: Negative LIMIT and OFFSET?

From: "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
To: "Andrew Sullivan" <ajs(at)crankycanuck(dot)ca>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Negative LIMIT and OFFSET?
Date: 2007-12-14 03:01:43
Message-ID: 36e682920712131901jf10e51dk9054757600d7ee17@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On Dec 13, 2007 9:43 PM, Andrew Sullivan <ajs(at)crankycanuck(dot)ca> wrote:
> I dimly remember some discussion of this issue once before, maybe a year
> ago.  My memory isn't what it was, and I can't find it by trolling archives,
> but I recall Tom saying that it was dumb, yes, but don't do that, because
> there's some reason not to change it.  I know, helpful search terms R me.

Man, maybe my mad Google skillz are not as mad as I thought :(

The best I could come up with was on my first try, though as it's just
a reply to a user asking for a different behavior of it, I doubt this
is it:

http://archives.postgresql.org/pgsql-general/2002-10/msg01293.php

Google search terms:

site:archives.postgresql.org "tom lane" "limit -1" "negative"

While I haven't looked at the code myself, I tend to agree with Simon
and Greg... I know of no reason to allow a negative limit/offset.

-- 
Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324
EnterpriseDB Corporation                | fax: 732.331.1301
499 Thornall Street, 2nd Floor          | jonah(dot)harris(at)enterprisedb(dot)com
Edison, NJ 08837                        | http://www.enterprisedb.com/

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2007-12-14 03:06:35
Subject: Re: Negative LIMIT and OFFSET?
Previous:From: Andrew SullivanDate: 2007-12-14 02:43:28
Subject: Re: Negative LIMIT and OFFSET?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group