Re: constraint expression - Mailing list pgsql-general

On Fri, 6 Aug 2004, Roger Niederland wrote:

> create table test (a int, b int, c int,
> constraint aname check (((a=0) and (b is not null)) or ((a=1) and (c
> is not null)));
>

You are missing the closing ) for the create table statement.

Kris Jurka