money with 4 digits after dot

From: Konstantin Izmailov <pgfizm(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: money with 4 digits after dot
Date: 2013-03-27 16:10:39
Message-ID: CAAw-Msf7R=juPkXDHY9KwZ=yMyF_UoR5NjE1+dupiVJqWWpzKA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

I'm trying to insert data into Postgres using COPY command. The data
originates from AdventureWorksDW. However, it fails with: "ERROR: invalid
input syntax for type money: "2171.2942" "

Is it possible to import money into Postgres with 4 digits after the dot?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kevin Grittner 2013-03-27 16:23:57 Re: Why does Postgres allow duplicate (FK) constraints
Previous Message Ian Lawrence Barwick 2013-03-27 15:07:19 Re: Understanding behavior of SELECT with multiple unnested columns

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2013-03-27 16:20:26 Re: [COMMITTERS] pgsql: Add PF_PRINTF_ATTRIBUTE to on_exit_msg_fmt.
Previous Message Simon Riggs 2013-03-27 16:10:02 Re: [COMMITTERS] pgsql: Allow external recovery_config_directory