Re: LIMIT NULL

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: "David E(dot) Wheeler" <david(at)kineticode(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: LIMIT NULL
Date: 2009-02-02 17:58:21
Message-ID: 200902021758.n12HwLo01930@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

In response to

  • LIMIT NULL at 2009-01-31 22:28:15 from David E. Wheeler

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2009-02-02 18:03:34 Re: LIMIT NULL
Previous Message Zdenek Kotala 2009-02-02 17:54:29 Re: [PATCH] Space reservation v02