On Mon, Feb 2, 2009 at 12:58 PM, Bruce Momjian <br...@momjian.us> wrote: > David E. Wheeler wrote: >> Howdy, >> >> Is it intentional that `LIMIT NULL` means the same as `LIMIT ALL`? If >> so, I'd like to submit a patch to document it, because I've found it >> useful in SQL functions: >> >> http://justatheory.com/computers/databases/postgresql/dynamic-limit.html > > Uh, I figure LIMIT NULL should return no rows.
Wouldn't that be LIMIT 0? Per SQL spec, doesn't NULL refer to an unknown quantity? Making it mean ALL seems more useful than making it mean 0, since you can already write 0 if you want 0. ...Robert -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
