Re: unexpected check constraint violation

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