Re: Field Constraints

On 6 Mar 2002 at 11:47, 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
>

[snip]


> --  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', 'cofee', 'chocolate' or 'espresso', how should that be
> constructed?

Try:

found_in_ports         boolean               not null
        default 'N'
        check (
            found_in_ports in ('Y','N'))

The same way as the above AFAIK>
--
Dan Langille
The FreeBSD Diary - http://freebsddiary.org/ - practical examples