The following bug has been logged on the website:
Bug reference: 14084
Logged by: pguser
Email address: pgu@mailcatch.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"
pgu@mailcatch.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