| 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
| 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 |