unexpected check constraint violation - Mailing list pgsql-general

From Jacek Becla
Subject unexpected check constraint violation
Date
Msg-id 49C7E8E1.4000905@SLAC.Stanford.EDU
Whole thread Raw
Responses Re: unexpected check constraint violation
Re: unexpected check constraint violation
Re: unexpected check constraint violation
List pgsql-general
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [SQL] bash & postgres
Next
From: Jeremy Harris
Date:
Subject: Re: unexpected check constraint violation