Postgres Pro
Downloads
Home   >   mailing lists

Re: The syntax about CREATE DOMAIN - Mailing list pgsql-bugs

From Tom Lane
Subject Re: The syntax about CREATE DOMAIN
Date
Msg-id 16938.1077860579@sss.pgh.pa.us
Whole thread Raw
In response to The syntax about CREATE DOMAIN  ("Gary WAN" <wan_on@hotmail.com>)
List pgsql-bugs
Tree view 
"Gary WAN" <wan_on@hotmail.com> writes:
>   Create Domain GenderDomain CHAR(1) Constraint g Check Value in ('M','F');

You need parentheses around the check expression.  AFAICS this is per
spec.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: The syntax about CREATE DOMAIN
Next
From: Tom Lane
Date:
Subject: Re: Optimizer problem with subselect.c?