The following bug has been logged online:
Bug reference: 2390
Logged by: Andreas Kretschmer
Email address: [EMAIL PROTECTED]
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?
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
