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@yahoo.com> wrote:

> --- 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.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend

--
Henrique Pantarotto <henpa@terra.com.br>
http://henrique.pantarotto.com.br/