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 <[EMAIL PROTECTED]> wrote: > --- On Mon, 12/24/07, Henrique Pantarotto <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> http://henrique.pantarotto.com.br/ ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
