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 <[EMAIL PROTECTED]> PGP Key: http://www.rbt.ca/rbtpub.asc
signature.asc
Description: This is a digitally signed message part