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@xxxxxxxxx> wrote: > --- 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 -- Henrique Pantarotto <henpa@xxxxxxxxxxxx> http://henrique.pantarotto.com.br/ ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
