Bah, scratch that, sorry again. It's because "CONSTRAINT" is implied by the reference to CREATE DOMAIN, isn't it? Sorry.
On Mon, Dec 4, 2023 at 8:29 PM PG Doc comments form <nore...@postgresql.org> wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/16/sql-alterdomain.html > Description: > > (apologies, I managed to send this too soon, just now, somehow) > > The example for ALTER DOMAIN shows: > > ALTER DOMAIN zipcode ADD CONSTRAINT zipchk CHECK (char_length(VALUE) = 5); > > ...yet the syntax suggests no CONSTRAINT-keyword (I'm guessing?) should be > used: > > ALTER DOMAIN name ADD domain_constraint [ NOT VALID ] > > When it should, I think? >
