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/