Subject | RE: [firebird-support] MySQL Enum type? |
---|---|
Author | Sasha |
Post date | 2007-06-03T19:57:52Z |
> > Does Firebird have something like the MySQL Enum datatype?I agree, luckily no enums. But if I have understood mysql docs on the
> or is there
> > a workaround?
>
> Luckily, it does not :-)
>
subject enums are just a subset of check constraint.
So, if you want for example a column that accepts only 'one', 'two', 'three'
as values you can define domain as follows:
create domain numbers as
char(5) not null
check (value in ('one', 'two', 'three'));
and use it as needed.
Of course, you don't need to create a domain, you can define a check
constraint on a table.
Sasha