Non-check constraint def for a static list ? - Mailing list pgsql-general

From Gauthier, Dave
Subject Non-check constraint def for a static list ?
Date
Msg-id 482E80323A35A54498B8B70FF2B8798004189C0D8F@azsmsx504.amr.corp.intel.com
Whole thread Raw
Responses Re: Non-check constraint def for a static list ?
Re: Non-check constraint def for a static list ?
Re: Non-check constraint def for a static list ?
List pgsql-general

Hi:

 

How could I define a constraint on a colum who’s value I want to restrict to a static list of strings?  For example, a column colled “gender” which cannot be NULL and must be either ‘M’ or ‘F’.  I can do it with a “check” constraint, but I can’t defer those constraints (the reason I’m asking for a non-check soln)

 

Thanks

pgsql-general by date:

Previous
From: std pik
Date:
Subject: hardware information
Next
From: Sam Mason
Date:
Subject: Re: Non-check constraint def for a static list ?