replacing mysql enum - Mailing list pgsql-sql

From Kenneth Gonsalves
Subject replacing mysql enum
Date
Msg-id 04121110305520.21547@thenilgiris.com
Whole thread Raw
Responses Re: replacing mysql enum
Re: replacing mysql enum
List pgsql-sql
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


pgsql-sql by date:

Previous
From: "Kevin B."
Date:
Subject: filtering
Next
From: Josh Berkus
Date:
Subject: Re: Cast NULL into Timestamp?