Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Subject: Constraint check is missing value check ARRAY
To: pgsql-docs@lists.postgresql.org
From: PG Doc comments form <noreply@postgresql.org>
Cc: eugene.losowskigallagher@googlemail.com
Reply-To: eugene.losowskigallagher@googlemail.com,
 pgsql-docs@lists.postgresql.org
Date: Fri, 11 Sep 2026 19:09:38 +0000
Message-ID: <178915377800.2258529.262291845008098767@wrigleys.postgresql.org>
Auto-Submitted: auto-generated
Archived-At: 
 <https://www.postgresql.org/message-id/178915377800.2258529.262291845008098767%40wrigleys.postgresql.org>
Precedence: bulk

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 =3D 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