hi, from mysql:
field enum('a','b','c') default null, i translated this as: field varchar(2) check (field in (null,'a','b','c')), is it necessary to put the 'null' in the check condition? if not will pg permit you to enter a null value in the field? regards kg ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])