[HACKERS] strange behaviour of parser - numeric domain doesn't work phantom

[Pavel Stehule]

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)

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend