CREATE UNIQUE INDEX name ON table (column [, ...]) [ NULLS [ NOT ] DISTINCT ];

2024-11-10 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/indexes-unique.html Description: This says it works from 12 onwards but actually from 15 onwards Prior to 15 unique partial indexes needed creating, e.g. (parent_ID, NAME) where parent_ID

Documentation error in tutorial page for Window Functions

2024-11-10 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/tutorial-window.html Description: In Section 3.5 Window Functions, the sentence that currently says: "As shown here, the rank function produces a numerical rank for each distinct ORDER BY

Re: Document how to run only specific regress tests

2024-11-10 Thread jian he
hi. maybe verbose, the following is the my intended changes based on your patch. what do you think? Running Specific Tests You can run a subset of the regression tests through the TESTS environment variable. One way to do it is set TESTS environment variable beforehand: export T