Re: how to alter an enum type

--- On Mon, 12/24/07, Henrique Pantarotto <henpa@terra.com.br> wrote:

> I tried searching the documentation and mailing list, and I
> couldn't
> figure this one out.

 ALTER TABLE questions
ALTER COLUMN answers TYPE possible_answers;

Actually your type is fine.  you only need to alter the column on your table to use your new type.

Regards,
Richard Broersma Jr.