Re: [HACKERS] Open 6.5 items

> > SELECT ... WHERE col ~ '(foo|bar)' works, but CHECK on table always fails
> 
> Does not reproduce here.
> 
> test=> create table t2 (i text check(i ~ '(foo|bar)'));
> CREATE
> test=> insert into t1 values ('aaa');
> ERROR:  ExecAppend: rejected due to CHECK constraint t1_i
> test=> insert into t1 values ('foo');
> INSERT 18634 1

Thanks.  Removed.

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026