Casting money to numeric(10,2)

Поиск
Список
Период
Сортировка
От Ben Stringer
Тема Casting money to numeric(10,2)
Дата
Msg-id 3A5D1630.1D16C46A@magicrock.net
обсуждение исходный текст
Ответы Removing the row limit
Re: Casting money to numeric(10,2)
Список 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@burbong.com    http://www.burbong.com   ph 0402 211 638

В списке pgsql-general по дате отправления:

Предыдущее
От: Richard Seymour
Дата:
Сообщение: automatic timestamp question
Следующее
От: Tom Lane
Дата:
Сообщение: Re: "Cluster" means "tangle" for me