Re: LIMIT NULL - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: LIMIT NULL
Date
Msg-id 4986E278.EE98.0025.0@wicourts.gov
Whole thread Raw
In response to Re: LIMIT NULL  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
>>> Bruce Momjian <bruce@momjian.us> wrote:
> David E. Wheeler wrote:
>> Is it intentional that `LIMIT NULL` means the same as `LIMIT ALL`?
> Uh, I figure LIMIT NULL should return no rows.
Why?  Since the normal meaning of NULL is "value unknown or does not
apply" it would seem to be most reasonable, if it's going to be
accepted in a LIMIT clause, to have it mean "the LIMIT does not
apply".
Plus, if it has been accepted with the "no limit" semantics, wouldn't
it require a really good reason to break backwards compatibility?
-Kevin



pgsql-hackers by date:

Previous
From: "David E. Wheeler"
Date:
Subject: Re: LIMIT NULL
Next
From: Zdenek Kotala
Date:
Subject: Re: new buildfarm client code feature release