============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Raphael Finkel
Your email address : raphael@cs.uky.edu
Category : runtime: back-end: SQL
Severity : non-critical
Summary: Regexp does not allow alternation in CHECK clause
System Configuration
--------------------
Operating System : Linux 2.0.36 ELF Slackware
PostgreSQL version : 6.4.2
Compiler used : egcs-2.90.29egcs-2.90.29
Hardware:
---------
Linux zonker 2.0.36 #2 Sun Jan 10 17:51:07 EST 1999 i686 unknown
Versions of other tools:
------------------------
--------------------------------------------------------------------------
Problem Description:
--------------------
I can SELECT ... WHERE col ~ '(foo|bar)', but if I
put a CHECK clause on a CREATE TABLE with the same
expression, the check always fails.
--------------------------------------------------------------------------
Test Case:
----------
--------------------------------------------------------------------------
Solution:
---------
--------------------------------------------------------------------------