The syntax about CREATE DOMAIN - Mailing list pgsql-bugs

Dear Sir,
  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