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


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

On Tue, 24 Feb 2004, Gary WAN wrote:


sszabo=# \h create domain
Command: CREATE DOMAIN
Description: define a new domain
Syntax:
CREATE DOMAIN name [AS] data_type
[ DEFAULT expression ]
[ constraint [ ... ] ]

where constraint is:

[ CONSTRAINT constraint_name ]
{ NOT NULL | NULL | CHECK (expression) }

Note the parentheses around the check expression.

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

"Gary WAN" <wan_on (AT) hotmail (DOT) com> writes:
You need parentheses around the check expression. AFAICS this is per
spec.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings