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

From: "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>
To: "PostgreSQL-development Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: strange behaviour of parser - numeric domain doesn't work phantom
Date: 2007-08-13 07:51:46
Message-ID: 162867790708130051i519bb900r36ff9bea632fa581@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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)

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Gregory Stark 2007-08-13 09:07:41 Re: Maximum row size
Previous Message Devrim GÜNDÜZ 2007-08-13 06:33:05 Maximum row size