The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/18/ddl-constraints.html Description:
Hi Documentation team This page is missing the value check array. https://www.postgresql.org/docs/current/ddl-constraints.html Example: CREATE TABLE demo ( id bigint NOT NULL DEFAULT nextval('seq_ttelephone_id'::regclass), usage character(1) NOT NULL DEFAULT 'M', CONSTRAINT ck_ttelephone_usage_1 CHECK (usage = ANY (ARRAY['M'::character(1),'H'::character(1),'W'::character(1),'F'::character(1)])) NOT VALID ) ); This is entirely missing from the documentation. Key thing to point out is the type cast must match: e.g. character(1) for type of character(1) etc Please add this to the documentation, last knowledge on web for this is 10-years old, and this is a current feature of postgres (using 17.11 currently) Many thanks Eugene
