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

Responses

• Re: replacing mysql enum at 2004-12-11 12:25:37 from Ian Barwick
• Re: replacing mysql enum at 2004-12-11 18:16:25 from Josh Berkus

pgsql-sql by date

Next:	From: Josh Berkus	Date: 2004-12-11 05:11:28
	Subject: Re: Cast NULL into Timestamp?
Previous:	From: Michael Fuhr	Date: 2004-12-11 04:11:52
	Subject: Re: Create Calendar