Re: [GENERAL] Alter Column from inet to inet[]

2012-03-14 Thread Tom Lane
Alex - writes: > Hi,I need to change a column type from inet to inet[] but the alter command > always gives me the following errors > ERROR: column "access_ip" cannot be cast to type inet[] > ALTER TABLE users ALTER COLUMN access_ip SET DATA TYPE inet[] USING > access_ip::inet[]; The problem i

[GENERAL] Alter Column from inet to inet[]

2012-03-14 Thread Alex -
Hi,I need to change a column type from inet to inet[] but the alter command always gives me the following errors ERROR: column "access_ip" cannot be cast to type inet[] ALTER TABLE users ALTER COLUMN access_ip SET DATA TYPE inet[] USING access_ip::inet[]; Tried various but no luck. Couldn't fin