Skip site navigation (1) Skip section navigation (2)

Re: BUG #3056: strange behave of CHECK constraint

From: Douglas Toltzman <doug(at)oakstreetsoftware(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3056: strange behave of CHECK constraint
Date: 2007-02-22 16:55:53
Message-ID: A50EAC81-4B14-4BF6-B014-E57A8B13DBA0@oakstreetsoftware.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Is it just me, or did you reverse the sense of your check.  In the  
first case, you select with "[^0-9]", but your constraint uses  
"[0-9]" without the carrot.

On Feb 22, 2007, at 4:48 PM, Pavel Stehule wrote:

>
> The following bug has been logged online:
>
> Bug reference:      3056
> Logged by:          Pavel Stehule
> Email address:      pavel(dot)stehule(at)hotmail(dot)com
> PostgreSQL version: 8.3
> Operating system:   Linux
> Description:        strange behave of CHECK constraint
> Details:
>
> Hello,
>
> check constraint doesn't work correct:
>
> opeerator similar works well:
>
> root=# select '233' not similar to '%[^0-9]%';
>  ?column?
> ----------
>  t
> (1 řádka)
>
> but:
> root=# create table tt(a varchar check (a not similar to '%[0-9]%'));
> CREATE TABLE
> root=# insert into tt values('233');
> ERROR:  new row for relation "tt" violates check constraint  
> "tt_a_check"
>
> Regards
> Pavel Stehule
>
> ---------------------------(end of  
> broadcast)---------------------------
> TIP 6: explain analyze is your friend

Douglas Toltzman
doug(at)oakstreetsoftware(dot)com
(910) 526-5938



In response to

pgsql-bugs by date

Next:From: Peter EisentrautDate: 2007-02-22 17:57:26
Subject: Re: BUG #3056: strange behave of CHECK constraint
Previous:From: Pavel StehuleDate: 2007-02-22 16:48:58
Subject: BUG #3056: strange behave of CHECK constraint

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group