From: | Ben Stringer <ben(at)magicrock(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Casting money to numeric(10,2) |
Date: | 2001-01-11 02:10:56 |
Message-ID: | 3A5D1630.1D16C46A@magicrock.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm trying to migrate several tables from a 6.5.2 DB to a
7.0.2 DB, and having trouble casting money (in the old DB)
to numeric(10,2) prior to doing a pg_dump.
I can create a table in the 6.5.2 DB with fields of type
numeric(10,2), but when I try and insert into this table
Ie.
insert
into new (purchase_price)
select
purchase_price::numeric(10,2)
from
old
;
I get ERROR: No such function 'numeric' with the specified attributes
I tried the 6.5.2 documentation, but it looked to me like this should
work.
Any suggestions appreciated.
Thanks, Ben
--
_____________________________________________________________
Ben Stringer
Burbong Consultants P/L ACN 092 664 198
ben(at)burbong(dot)com http://www.burbong.com ph 0402 211 638
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-01-11 03:00:02 | Re: "Cluster" means "tangle" for me |
Previous Message | Ben Stringer | 2001-01-11 02:00:46 | Casting money to numeric(10,2) |