On Monday 01 January 2007 1:45 pm, Ken Winter wrote:
> I want to convert a column named "amount", currently of type money, to type
> numeric(10,2).
>
> When I try to do this using:
>
> ALTER TABLE transaction ALTER COLUMN amount TYPE NUMERIC(10,2);
>
> I get:
>
> PostgreSQL Error Code: (1)
> ERROR:
I want to convert a column named "amount", currently of type money, to type
numeric(10,2).
When I try to do this using:
ALTER TABLE transaction ALTER COLUMN amount TYPE NUMERIC(10,2);
I get:
PostgreSQL Error Code: (1)
ERROR: column "amount" cannot be cast to type "pg_catalog.numeric"
So t