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

BUG #2390: check constraint

From: "Andreas Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2390: check constraint
Date: 2006-04-12 13:56:41
Message-ID: 200604121356.k3CDufEq016831@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      2390
Logged by:          Andreas Kretschmer
Email address:      andreas(dot)kretschmer(at)schollglas(dot)com
PostgreSQL version: 8.1.3
Operating system:   Debian Linux
Description:        check constraint
Details: 

i want to add a check constraint like:

create table foo (i char(7) CHECK (i ~ '^[0-9]{6,7}$'));

i doesn't work, but if works, if i change the type for i to varchar(7).

Bug or feature?

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2006-04-12 14:37:27
Subject: Re: right sibling is not next child
Previous:From: Peter BrantDate: 2006-04-12 13:24:06
Subject: Re: right sibling is not next child

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