| From: | PG Doc comments form <noreply(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-docs(at)lists(dot)postgresql(dot)org |
| Cc: | jbe-mlist(at)magnetkern(dot)de |
| Subject: | Parameter NOT NULL to CREATE DOMAIN not the same as CHECK (VALUE IS NOT NULL) |
| Date: | 2025-01-03 13:39:44 |
| Message-ID: | 173591158454.714.7664064332419606037@wrigleys.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs pgsql-hackers |
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/17/sql-createdomain.html
Description:
The manual claims:
The syntax NOT NULL in this command is a PostgreSQL extension. (A
standard-conforming way to write the same would be CHECK (VALUE IS NOT
NULL). […])
But both variants differ when composite types are involved:
CREATE TYPE complex AS (real float8, imag float8);
CREATE DOMAIN d1 AS complex NOT NULL;
CREATE DOMAIN d2 AS complex CHECK (VALUE IS NOT NULL);
SELECT '(,)'::d1; -- allowed
SELECT '(,)'::d2; -- not allowed
Kind Regards,
Jan Behrens
| From | Date | Subject | |
|---|---|---|---|
| Next Message | jian he | 2025-01-06 10:19:23 | Re: LC_COLLATE is visible in the documentation for PostgreSQL 17, but it is not supported |
| Previous Message | PG Doc comments form | 2024-12-30 12:06:40 | LC_COLLATE is visible in the documentation for PostgreSQL 17, but it is not supported |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2025-01-03 13:44:22 | Re: magical eref alias names |
| Previous Message | Robert Haas | 2025-01-03 13:33:02 | Re: Fwd: Re: A new look at old NFS readdir() problems? |