Re: unexpected check constraint violation - Mailing list pgsql-general

On Mar 23, 2009, at 2:54 PM, Jacek Becla wrote:

> Hi,
>
> Can someone explain why postgres complains in this case:
>
> create table t(d real, check(d>=0.00603));
> insert into t values (0.00603);
>
> ERROR:  new row for relation "t" violates check constraint "t_d_check"
>
> thanks
> Jacek


try this:

insert into t values (0.00603::real);

Ries