About "Alter table... alter column.. TYPE ... "

From: Ying Lu <ying_lu(at)cs(dot)concordia(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: About "Alter table... alter column.. TYPE ... "
Date: 2005-04-18 20:38:49
Message-ID: 42641AD9.60708@cs.concordia.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello,

To alter table column from varchar(32) to date. "Alter table" command
does not seem to work:

alter table test alter column col type date ;
ERROR: column "col1" cannot be cast to type "date"

Tks,
Emi

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Rod Taylor 2005-04-18 21:09:46 Re: About "Alter table... alter column.. TYPE ... "
Previous Message Michael Fuhr 2005-04-18 19:07:53 Re: User Defined Functions Errors