Re: Constraint check is missing value check ARRAY

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