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