Ray Hunter wrote:
> I am trying to convert a data type in mysql to postgresql and was wondering
> which one i would use in pgsql.
>
> the type is "set" (example):
>
> name set( 'val1', 'val2', 'val3' ) NOT NULL DEFAULT 'val2'
>
> How can i do that in pgsql?
Sure:
x CHAR(4) NOT NULL DEFAULT 'val2' CHECK (x = 'val1' OR x = 'val2' ...)
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073