Extracting data from deprecated MONEY fields - Mailing list pgsql-general

From Ken Winter
Subject Extracting data from deprecated MONEY fields
Date
Msg-id 009b01c8c781$b5dac0a0$6703a8c0@KenIBM
Whole thread Raw
Responses Re: Extracting data from deprecated MONEY fields
List pgsql-general

I understand from http://www.postgresql.org/docs/8.0/static/datatype-money.html that the “money” data type is deprecated. 

 

So I want to convert the data from my existing “money” columns into new un-deprecated columns, e.g. with type “decimal(10,2)”.  But every SQL command I try tells me I can’t cast or convert “money” data into any other type I have tried, including decimal, numeric, varchar, and text. 

 

Is there any way to do this?

 

~ TIA

~ Ken

pgsql-general by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: Annoying messages when copy sql code to psql terminal
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Extracting data from deprecated MONEY fields