On Tue, Sep 15, 2009 at 08:01:19AM -0700, Gauthier, Dave wrote: > 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)
If this is to do with your similar questions from earlier; at what point does the data become valid and why don't you just delay putting the data into the "real" table at then. -- Sam http://samason.me.uk/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
