X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B2E61533C8 for ; Mon, 18 Apr 2005 17:39:02 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 77860-07 for ; Mon, 18 Apr 2005 20:38:53 +0000 (GMT) Received: from perseverance.encs.concordia.ca (perseverance-96.encs.concordia.ca [132.205.96.94]) by svr1.postgresql.org (Postfix) with ESMTP id 3B93B533D0 for ; Mon, 18 Apr 2005 17:38:49 -0300 (ADT) Received: from [132.205.44.35] (IDENT:emilu@curacao.cs.concordia.ca [132.205.44.35]) by perseverance.encs.concordia.ca (8.12.11/8.12.11) with ESMTP id j3IKcoVt000848 for ; Mon, 18 Apr 2005 16:38:50 -0400 Message-ID: <42641AD9.60708@cs.concordia.ca> Date: Mon, 18 Apr 2005 16:38:49 -0400 From: Ying Lu User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: About "Alter table... alter column.. TYPE ... " Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Scanned-By: MIMEDefang 2.43 on perseverance.encs.concordia.ca at 2005/04/18 16:38:50 EDT X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.035 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200504/256 X-Sequence-Number: 21149 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