On Fri, 2026-09-11 at 19:09 +0000, PG Doc comments form wrote: > 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
Which aspect of this requires more detailed documentation than already exists? Can you be more descriptive? Yours, Laurenz Albe
