| From: | "Gary WAN" <wan_on(at)hotmail(dot)com> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | The syntax about CREATE DOMAIN |
| Date: | 2004-02-24 10:07:46 |
| Message-ID: | BAY9-F451GyJKsDo9rS00004838@hotmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martin Langhoff | 2004-02-24 10:47:48 | Re: BUG #1083: Insert query reordering interacts badly with |
| Previous Message | Tom Lane | 2004-02-24 06:51:55 | Re: BUG #1083: Insert query reordering interacts badly with NEXTVAL()/CURRVAL() |