constraint expression

[Roger Niederland]

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

[Gaetano Mendola]

Roger Niederland wrote:

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'

Works on 7.4:

regression=# create table test (a int, b int, c int,
regression(# constraint aname check (((a=0) and (b is not null)) or ((a=1) and (c
regression(# is not null))));
CREATE TABLE
you forgot to ")".


Regards
Gaetano Mendola

[Kris Jurka]

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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)