Re: How to use the SET data type? Help plz! - Mailing list pgadmin-support

> I see your points.  So how is the best way to implement this type of "set" idea 
> in something like postgres?  Say I have a column named primary colors, and I 
> want to limit this to red, blue, and yellow.  How is the best way to do this 
> without a mysql set?

CREATE TABLE foo (color varchar(255) NOT NULL,CHECK (color IN ('red', 'blue', 'yellow'))
};

Chris