Skip site navigation (1) Skip section navigation (2)

The syntax about CREATE DOMAIN

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 (view raw or flat)
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


Responses

pgsql-bugs by date

Next:From: Martin LanghoffDate: 2004-02-24 10:47:48
Subject: Re: BUG #1083: Insert query reordering interacts badly with
Previous:From: Tom LaneDate: 2004-02-24 06:51:55
Subject: Re: BUG #1083: Insert query reordering interacts badly with NEXTVAL()/CURRVAL()

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group