constraint expression - Mailing list pgsql-general

From 2004@niederland.com (Roger Niederland)
Subject constraint expression
Date
Msg-id 89683d03.0408061714.4ed01320@posting.google.com
Whole thread Raw
Responses Re: constraint expression
List pgsql-general
Hello,

I am having problems adding a simple expression to a table level
constraint.
Here is an example of one which postgresql 7.4.3 does not accept.

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)));

Should this work?  It is complaining 'ERROR:  syntax error at or near
";" at character 126'

Thanks

pgsql-general by date:

Previous
From: Chris Travers
Date:
Subject: Re: Is olap possible on postgresql????
Next
From: Thiemo Kellner
Date:
Subject: Error >>syntax error<< at >>$1<< at character 53