money with 4 digits after dot

Started by Konstantin Izmailovalmost 13 years ago3 messages

pgfizm@gmail.com

almost 13 years ago

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?

Tom Lane

tgl@sss.pgh.pa.us

almost 13 years ago

In reply to: Konstantin Izmailov (#1)

Re: money with 4 digits after dot

Konstantin Izmailov <pgfizm@gmail.com> writes:

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

You would need to set lc_monetary to a locale that permits that.

regards, tom lane

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Konstantin Izmailov

pgfizm@gmail.com

almost 13 years ago

In reply to: Tom Lane (#2)

Re: [HACKERS] money with 4 digits after dot

I found a workaround: domain type defined as: CREATE DOMAIN currency AS
numeric(16,4);
Thank you!