domain check constraint syntax problem for 7.4 - Mailing list pgsql-hackers

From Bruno Wolff III
Subject domain check constraint syntax problem for 7.4
Date
Msg-id 20030126050921.GA12231@wolff.to
Whole thread Raw
Responses Re: domain check constraint syntax problem for 7.4  (Rod Taylor <rbt@rbt.ca>)
List pgsql-hackers
I am trying to create a domain with more than one check constraint and
I am getting an error that I don't think is correct according to the
documentation. I am not sure if this is a limitation of a partially
implemented feature or a bug that has so far been overlooked.

For example:
area=# create domain test6 as int constraint ack check(value<4);
CREATE DOMAIN
area=# create domain test7 as int constraint ack check(value<4),
area-# constraint ack1 check(value>0);
ERROR:  parser: syntax error at or near "," at character 57
area=# create domain test7 as int check(value<4), check(value>0);
ERROR:  parser: syntax error at or near "," at character 42


pgsql-hackers by date:

Previous
From: Justin Clift
Date:
Subject: Re: [CYGWIN] Have a PG 7.3.1 Windows (cygwin) easy installer... now
Next
From: Rod Taylor
Date:
Subject: Re: domain check constraint syntax problem for 7.4