Re: ALTER TABLE syntax incomplete

2020-03-04 Thread Michael Paquier
On Fri, Feb 28, 2020 at 04:26:57PM +, PG Doc comments form wrote: > I believe the documentation page > https://www.postgresql.org/docs/11/sql-altertable.html is missing the action > ADD CONSTRAINT, as it is mentioned in the descriptions of other keywords. The documentation includes this descri

Re: Error in docs

2020-03-04 Thread Michael Paquier
On Tue, Mar 03, 2020 at 01:30:15PM +, PG Doc comments form wrote: > In the block after this sentence: "This acquires a row-level lock on the row > with the specified account number. Then, the second transaction executes:" > The second update statement has the worng What do you think is wrong h

Re: Possible typos in the #12.1.1 examples

2020-03-04 Thread Michael Paquier
On Mon, Mar 02, 2020 at 03:38:01PM +, PG Doc comments form wrote: > Seems like here the example missed 'm' as an alias and a dot in the `where` > clause: > ... messages m > ... m.id = 12; This query is valid as-is. > SELECT m.title || ' ' || m.author || ' ' || m.abstract || ' ' || d.body AS >

Error in docs

2020-03-04 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.5/explicit-locking.html Description: https://www.postgresql.org/docs/12/explicit-locking.html In the block after this sentence: "This acquires a row-level lock on the row with the specifie

Possible typos in the #12.1.1 examples

2020-03-04 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/textsearch-intro.html Description: SELECT title || ' ' || author || ' ' || abstract || ' ' || body AS document FROM messages WHERE mid = 12; Seems like here the example missed 'm' as an

ALTER TABLE syntax incomplete

2020-03-04 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/sql-altertable.html Description: I believe the documentation page https://www.postgresql.org/docs/11/sql-altertable.html is missing the action ADD CONSTRAINT, as it is mentioned in the des

Minor error

2020-03-04 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/indexes-partial.html Description: A sentence on this page reads: "The system can recognize simple inequality implications, for example “x < 1” implies “x < 2”; otherwise the predicate cond