Hi Martin, Thank you for your reply. My main reason for wanting to use some sort of enum type is to actually enforce a limit on the values that can be entered into the database. I can also enforce this limit in my application but I prefer to do add those kinds of constraints to the database itself but I guess that isn't possible (yet). Best regards, Dennis On 21-11-2013 10:07, Martin Kersten wrote:

Hi

No, there is no such thing as enum types. If the enum type has limited number of values, you can use the String, because duplicate elimination will result in very short 'enum' values, i.e. byte-wide references into the string dictionary.

regards, Martin

On 11/21/13 9:51 AM, Dennis Pallett wrote:

...

Hello all,

Does MonetDB support some kind of enum type, similar to MySQL's enum type (http://dev.mysql.com/doc/refman/5.0/en/enum.html), i.e. a column that only allows a limited set of values?

I couldn't find it in the documentation and I'm unable to simulate it with triggers or constraints.

Best regards, Dennis Pallett _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list