Postgres Pro
Downloads
Home   >   mailing lists

money with 4 digits after dot - Mailing list pgsql-hackers

From Konstantin Izmailov
Subject money with 4 digits after dot
Date
Msg-id CAAw-Msf7R=juPkXDHY9KwZ=yMyF_UoR5NjE1+dupiVJqWWpzKA@mail.gmail.com
Whole thread Raw
Responses Re: money with 4 digits after dot  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view
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?

pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: [COMMITTERS] pgsql: Allow external recovery_config_directory
Next
From: Heikki Linnakangas
Date:
Subject: Re: [COMMITTERS] pgsql: Add PF_PRINTF_ATTRIBUTE to on_exit_msg_fmt.