Re: domain check constraint syntax problem for 7.4

They work the same as table constraints with in-line declaration (no
comma).

On Sun, 2003-01-26 at 00:09, Bruno Wolff III wrote:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
--
Rod Taylor <rbt@rbt.ca>

PGP Key: http://www.rbt.ca/rbtpub.asc