I would like to tell you that the SQL about "Create Domain" is still cannot involve constraints other than NULL | NOT NULL in Postgresql 7.4.1.
For instances, when I type the following sentences, it shows error message:
Create Domain GenderDomain CHAR(1) Constraint g Check Value in ('M','F');
Error: syntax error at or new "VALUE" at character ...
How can I obtain the correct syntax about domain in postgresql?
Regards, Gary
_________________________________________________________________
Get 10Mb extra storage for MSN Hotmail. Subscribe Now! http://join.msn.com/?pgmarket=en-hk
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
