ENUM is postgres

[rhaggert]

in mysql i could say
some_filed ENUM('a','b','c'...etc)

in posgres, how do i do this
there doesn't seem to be a enumerated data type.

Thanks
Ryan

[Sxooter]

Yeah, that's because enumerated types only exist in the MySQL universe.

What you do in Postgresql, and most other deatabases too, is use a check constraint:

create table test (name text, id serial, check_box text check (check_box in ('red','yellow','blue')));