On 06/10/11 11:02 AM, Carlos Mennens wrote:
On Fri, Jun 10, 2011 at 1:57 PM, Bill Moran<wmo...@potentialtech.com> wrote:
I don't think ALTER COLUMN TYPE will implicitly convert from varchar
to INT.
Try:
ALTER TABLE reference
ALTER COLUMN color
TYPE INT
USING CAST(color AS INT);
Your command suggestion worked perfect but can you explain why yours
worked and mine didn't? I've never used 'USING CAST' command before.
pgsql <= 8.3 was lax about char->other casting. due to some discovered
ambiguities, it was tightened up in 8.4+
--
john r pierce N 37, W 122
santa cruz ca mid-left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
