On Tue, 24 Feb 2004, Gary WAN wrote:
> 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?
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
