Re: how to alter an enum type

Hi Richard,

I actually want to change the enum values after I have created and
associated it to a table colum.

Is it possible?

Thanks.

On Mon, 24 Dec 2007 09:50:09 -0800 (PST)
Richard Broersma Jr <rabroersma(at)yahoo(dot)com> wrote:

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

--
Henrique Pantarotto <henpa(at)terra(dot)com(dot)br>
http://henrique.pantarotto.com.br/