Re: [GENERAL] Enumerated data type

[Peter Eisentraut]

Anand Raman writes:

> Is there anything equivalent to the enumerated data types in
> postgresql..

You might find that strings with check constraints will do the job, e.g.

create table my_tbl (
 ...
 color text check color in ('blue', 'green', 'white'),
 ...
);


-- 
Peter Eisentraut                  Sernanders v�g 10:115
[EMAIL PROTECTED]                   75262 Uppsala
http://yi.org/peter-e/            Sweden