Re: [HACKERS] money with 4 digits after dot

2013-03-27 Thread Konstantin Izmailov
I found a workaround: domain type defined as: CREATE DOMAIN currency AS numeric(16,4); Thank you!

Re: [HACKERS] money with 4 digits after dot

2013-03-27 Thread Tom Lane
Konstantin Izmailov 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 chan

[HACKERS] money with 4 digits after dot

2013-03-27 Thread Konstantin Izmailov
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?