Re: Synopsis of SELECT statement: UNION, INTERSECTION, EXCEPT

2018-03-15 Thread Tom Lane
Euler Taveira writes: > 2018-03-15 7:18 GMT-03:00 PG Doc comments form : >> The SYNOPSIS section of the "SELECT" SQL command contains the line >> [ { UNION | INTERSECT | EXCEPT } [ ALL | DISTINCT ] select ] >> (with a boldface "select"), but it is not clear what is meant by that >> "select". > It

Re: "IS NOT DOCUMENT" is missing

2018-03-15 Thread Euler Taveira
2018-03-09 0:10 GMT-03:00 PG Doc comments form : > From testing, it seems like PostgreSQL supports the syntax "IS NOT DOCUMENT" > in addition to "IS DOCUMENT", similar to "IS NOT NULL", "IS NOT FALSE", etc, > however this does not appear to be documented, only "IS DOCUMENT" is. > It has been like t

Re: Documentation for varbit is missing size parameter

2018-03-15 Thread Euler Taveira
2018-03-11 1:43 GMT-03:00 PG Doc comments form : > The documentation for the varbit data type is missing the size parameter "[ > (n) ]". > Good catch! It seems to be an oversight in commit 768b647ead78d0d63915c1708cad13c2468f9440. The attached patch adds it. -- Euler Taveira

Re: Synopsis of SELECT statement: UNION, INTERSECTION, EXCEPT

2018-03-15 Thread Euler Taveira
2018-03-15 7:18 GMT-03:00 PG Doc comments form : > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/10/static/sql-select.html > Description: > > The SYNOPSIS section of the "SELECT" SQL command contains the line > > [ { UNION | INTERSECT

Re: Can we only add values to enums?

2018-03-15 Thread Euler Taveira
2018-03-12 20:28 GMT-03:00 PG Doc comments form : > I need to add a value to an enum, so I found this page, which answered my > question. However, I found it quite confusing that it only documents adding > a value. I would expect it to also document how to remove a value from an > enum? Is this not

Problems with pg_upgrade under Windows

2018-03-15 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/static/pgupgrade.html Description: The postgresql service (since 9.x?) runs under Windows with the integrated NetworkService account and not with a dedicated postgres account anymore (at l

Synopsis of SELECT statement: UNION, INTERSECTION, EXCEPT

2018-03-15 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/static/sql-select.html Description: The SYNOPSIS section of the "SELECT" SQL command contains the line [ { UNION | INTERSECT | EXCEPT } [ ALL | DISTINCT ] select ] (with a boldface "sele