Re: LIMIT NULL - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: LIMIT NULL
Date
Msg-id 200902021758.n12HwLo01930@momjian.us
Whole thread Raw
In response to LIMIT NULL  ("David E. Wheeler" <david@kineticode.com>)
Responses Re: LIMIT NULL  (Robert Haas <robertmhaas@gmail.com>)
Re: LIMIT NULL  ("David E. Wheeler" <david@kineticode.com>)
Re: LIMIT NULL  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Re: LIMIT NULL  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +


pgsql-hackers by date:

Previous
From: Zdenek Kotala
Date:
Subject: Re: [PATCH] Space reservation v02
Next
From: Robert Haas
Date:
Subject: Re: LIMIT NULL