Domain Check Constraints

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