| Lists: | pgsql-bugs |
|---|
| From: | pgu(at)mailcatch(dot)com |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #14084: typo in LIMIT documentation |
| Date: | 2016-04-14 06:46:50 |
| Message-ID: | 20160414064650.22934.50562@wrigleys.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 14084
Logged by: pguser
Email address: pgu(at)mailcatch(dot)com
PostgreSQL version: 9.5.2
Operating system: all
Description:
http://www.postgresql.org/docs/current/static/queries-limit.html
[...]and LIMIT NULL is the same as omitting the LIMIT clause.
I guess it should be "LIMIT ALL" not "LIMIT NULL"
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | pgu(at)mailcatch(dot)com |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #14084: typo in LIMIT documentation |
| Date: | 2016-04-14 14:26:37 |
| Message-ID: | 22681.1460643997@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
pgu(at)mailcatch(dot)com writes:
> http://www.postgresql.org/docs/current/static/queries-limit.html
> [...]and LIMIT NULL is the same as omitting the LIMIT clause.
> I guess it should be "LIMIT ALL" not "LIMIT NULL"
No, it means what it says ... but I agree it's a bit confusing,
particularly because the case of OFFSET NULL isn't covered at
the same time.
regards, tom lane