From: | Jeff Self <jself(at)nngov(dot)com> |
---|---|
To: | Joseph Maxwell <jemaxwell(at)jaymax(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Setting up Field constraints |
Date: | 2002-03-07 14:23:07 |
Message-ID: | 1015510987.961.4.camel@personnel_test |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Why not use a Boolean type?
On Wed, 2002-03-06 at 18:51, Joseph Maxwell wrote:
> Hello,
> I have created a DB and TABLE but would like to constrain one field to
> accept either "YES" or "NO" only. How can I set this up?
> I have tried various syntactic constructs of
>
> Prior_Rx varchar(3) NULL CHECK ('Yes', 'No'),
> Prior_Rx varchar(3) NULL CHECK (VALUE 'Yes', 'No'),
> Prior_Rx varchar(3) NULL CHECK ('Yes', 'No'),
> Prior_Rx varchar(3) NULL CONSTRAINT (CHECK (VALUE 'Yes', 'No')),
> Prior_Rx varchar(3) NULL CONSTRAINT (CHECK ('Yes', 'No')),
> Prior_Rx varchar(3) NULL CONSTRAINT (CHECK (VALUE Yes, No)),
> Prior_Rx varchar(3) NULL CONSTRAINT (CHECK (Yes, No)),
> Prior_Rx varchar(3) NULL CONSTRAINT (CHECK (Yes OR No)),
> Prior_Rx varchar(3) NULL CHECK (Yes OR No),
> Prior_Rx varchar(3) NULL CHECK ('Yes' OR 'No'),
>
> Obviously they were all wrong, could someone advise?
> Thanks
>
> -- Joe --
> ---------------------------------------------------------------------------------------
> PS:
> Just learned that the datatype should be 'bool' in this case
>
> haven't tested it yet
>
> But had I wanted to restrict it to say either mike or john, or even one
> of a list say, 'tea', 'coffee', 'chocolate' or 'espresso', how should
> that be constructed?
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
--
Jeff Self
Information Technology Analyst
Department of Personnel
City of Newport News
2400 Washington Ave.
Newport News, VA 23607
757-926-6930
From | Date | Subject | |
---|---|---|---|
Next Message | Jesus Arocho | 2002-03-07 14:50:18 | libreadline.so |
Previous Message | Chris Gamache | 2002-03-07 13:56:28 | Re: improving performance of UNION and ORDER BY |