Christopher Kings-Lynne writes:
> > Generally, you'd use a text field with a check constraint. For example:
> >
> > CREATE TABLE car (
> > ...
> > color text check (color in ('blue', 'green', 'yellow')),
> > ...
> > );
>
> Nope - cos you need 'blue,green' as a value, etc. as well.
That's not an enumeration type, that's a set. For set's you create a
separate table.
--
Peter Eisentraut peter_e@gmx.net