Re: unexpected check constraint violation

From: Jeremy Harris <jgh(at)wizmail(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: unexpected check constraint violation
Date: 2009-03-23 20:41:06
Message-ID: 49C7F3E2.70305@wizmail.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christophe 2009-03-23 20:44:08 Re: unexpected check constraint violation
Previous Message Tom Lane 2009-03-23 19:55:13 Re: [SQL] bash & postgres