Regress:
test geometry ... FAILED
But I'm using FreeBSD 4.7 RELEASE (PostgreSQL 7.4-devel)
psql needs some additions to display the constraints, though I'm not
sure what at the moment.
Anyway, below is a sample:
a=# create domain i as integer not null check (value > 15 or value = 5)
check(value < 18);
CREATE DOMAIN
a=# select 7::i;
ERROR: Domain $1 constraint i failed
a=# select 5::i;
i
---
5
(1 row)
a=# select 15::i;
ERROR: Domain $1 constraint i failed
a=# select 20::i;
ERROR: Domain $2 constraint i failed
a=# select 17::i;
i
----
17
(1 row)
a=#
--
Rod Taylor