> > Thats not so trivial. The type set can have "zero or more values, each of
> > which must be chosen from a list of allowed values" (from Mysql-manual).
> > In PostgreSQL you have to use a details-table for this. This is a
> > nonstandard feature of Mysql (these people concentrate in creating
> > nonstandard extensions before supporting the full standard ;-)
>
> Oh, yes, it is enum that is CHECK. 'set' has multiple values. It is a
> nifty MySQL feature, I must say.
But not so tricky as it looks first. They use just a bitmask for it. The
maximum number of allowed values is limited to 64 so it must be a 8-Byte
bitmask.
What do you think? Wouldn't it be nice to have this feature? It shouldn't be
too hard to implement it.
Tommi