From: Noel Doydora <uwq291@lycos.com>
To: pgsql-sql@postgresql.org
Subject: cannot alter column data type to "date"
Date: Thu, 08 Dec 2005 15:12:07 +0800
Message-ID: <20051208071207.43903CA07E@ws7-4.us4.outblaze.com> (raw)
Below is the message I receive when I try to alter the data type of
a column to "date". I had to drop the column and add it again just
so I can set its data type to "date". How do I change a column's
data type to "date" without dropping and then creating it again?
Hoping for a kind response. Thank you.
SQL error:
ERROR: column "date_signed" cannot be cast to type "date"
In statement:
ALTER TABLE "canvass" ALTER COLUMN "date_signed" TYPE date
--
_______________________________________________
Search for businesses by name, location, or phone number. -Lycos Yellow Pages
http://r.lycos.com/r/yp_emailfooter/http://yellowpages.lycos.com/default.asp?SRC=lycos10
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: uwq291@lycos.com
Subject: Re: cannot alter column data type to "date"
In-Reply-To: <20051208071207.43903CA07E@ws7-4.us4.outblaze.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox