--- On Mon, 12/24/07, Henrique Pantarotto <henpa@xxxxxxxxxxxx> 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. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend