Postgres Pro
Downloads
Home   >   mailing lists

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

From Jeremy Harris
Subject Re: unexpected check constraint violation
Date
Msg-id 49C7F3E2.70305@wizmail.org
Whole thread Raw
In response to unexpected check constraint violation  (Jacek Becla <becla@slac.stanford.edu>)
Responses Re: unexpected check constraint violation  (Christophe <xof@thebuild.com>)
List pgsql-general
Tree view 
Jacek Becla wrote:
> 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"

Because equality is not well-defined for "real" values?

- Jeremy

pgsql-general by date:

Previous
From: Jacek Becla
Date:
Subject: unexpected check constraint violation
Next
From: Christophe
Date:
Subject: Re: unexpected check constraint violation