Hello
I am testing:
postgres=# create domain nb int check(value > 10);
CREATE DOMAIN
postgres=# select 11::nb;
nb
----
11
(1 row) -- ok
postgres=# select -11::nb;
?column?
----------
-11
(1 row) -- ughh
postgres=# select (-11)::nb; -- I understand
ERROR: value for domain nb violates check constraint "nb_check"
But nobody will write parentheses with alone negative number
Regards
Pavel Stehule
postgres=# select version();
version
-------------------------------------------------------------------------------------------------------
PostgreSQL 8.3devel on i686-pc-linux-gnu, compiled by GCC gcc (GCC)
4.1.2 20070502 (Red Hat 4.1.2-12)
(1 row)