Re: Possible documentation inaccuracy in optimizer README

2025-04-07 Thread Tom Lane
Zeyuan Hu writes: > In https://github.com/postgres/postgres/tree/master/src/backend/optimizer, > there are two examples on the dynamic programming (DP) algorithm used in > the optimizer, which I think > have some inaccuracy: You're right that these examples do not consider the effects of clauses

Possible documentation inaccuracy in optimizer README

2025-04-07 Thread Zeyuan Hu
Hello, In https://github.com/postgres/postgres/tree/master/src/backend/optimizer, there are two examples on the dynamic programming (DP) algorithm used in the optimizer, which I think have some inaccuracy: SELECT * FROMtab1, tab2, tab3, tab4 WHERE tab1.col = tab2.col AND ta

Re: Suggestion for docs, section "4.2.3 Subscripts": bounds and base

2025-04-07 Thread David G. Johnston
On Thursday, April 3, 2025, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/17/sql-expressions.html > Description: > > I skimmed over section 4.2 while waiting for a meeting to start and found > no > menti

Re: generated constraint name

2025-04-07 Thread David G. Johnston
On Sunday, April 6, 2025, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/17/ddl-alter.html > Description: > > url: > https://www.postgresql.org/docs/current/ddl-alter.html# > DDL-ALTER-REMOVING-A-CONSTRAI

Re: Re[2]: Suggestion for docs, section "4.2.3 Subscripts": bounds and base

2025-04-07 Thread Laurenz Albe
On Mon, 2025-04-07 at 09:07 +, Stefan Schmiedl wrote: > Wearing my documentation writer's hat, I agree that the information given on > one page need not be repeated on another one, especially if it's already > cross-referenced. > > However, with my documentation reader's glasses on, I would ha

Re[2]: Suggestion for docs, section "4.2.3 Subscripts": bounds and base

2025-04-07 Thread Stefan Schmiedl
-- Original Message -- From "Laurenz Albe" To s...@xss.de; pgsql-docs@lists.postgresql.org Date 07.04.2025 10:03:47 Subject Re: Suggestion for docs, section "4.2.3 Subscripts": bounds and base On Thu, 2025-04-03 at 18:22 +, PG Doc comments form wrote: Page: https://www.postgre

Re: Suggestion for docs, section "4.2.3 Subscripts": bounds and base

2025-04-07 Thread Laurenz Albe
On Thu, 2025-04-03 at 18:22 +, PG Doc comments form wrote: > Page: https://www.postgresql.org/docs/17/sql-expressions.html > Description: > > I skimmed over section 4.2 while waiting for a meeting to start and found no > mention of the following two questions that immediately pop up in my mind

generated constraint name

2025-04-07 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/ddl-alter.html Description: url: https://www.postgresql.org/docs/current/ddl-alter.html#DDL-ALTER-REMOVING-A-CONSTRAINT (If you are dealing with a generated constraint name like $2, don't

Suggestion for docs, section "4.2.3 Subscripts": bounds and base

2025-04-07 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/sql-expressions.html Description: I skimmed over section 4.2 while waiting for a meeting to start and found no mention of the following two questions that immediately pop up in my mind whe