Constraint check is missing value check ARRAY

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: eugene(dot)losowskigallagher(at)googlemail(dot)com
Subject: Constraint check is missing value check ARRAY
Date: 2026-09-11 19:09:38
Message-ID: 178915377800.2258529.262291845008098767@wrigleys.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Laurenz Albe 2026-09-13 21:41:40 Re: Constraint check is missing value check ARRAY
Previous Message Ayush Tiwari 2026-09-11 05:09:53 Re: Fix primary status update WAL position description