Postgres Pro
Downloads
Home   >   mailing lists

Invalid precision for money datatype - Mailing list pgsql-bugs

From SriRaghu Sai Kasyap
Subject Invalid precision for money datatype
Date
Msg-id SN2PR15MB099251E27BA21B2E6655CF15DE9A0@SN2PR15MB0992.namprd15.prod.outlook.com
Whole thread Raw
Responses Re: Invalid precision for money datatype  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-bugs
Tree view

Hi,

 

We have a table created in Postgres database with money datatype and observed that the precision is shown as 2147483647 using a Java program. I am using Postgres driver jar postgresql-9.4-1203.jdbc42.jar and database version is 9.4.5.

 

I understand that the money datatype is locale specific and will not work similar to numeric columns, but we need the following information.

 

  1. How to get the locale for the money datatype column?
  2. How to get the precision and scale for the column given a locale?

 

Please answer the above questions.

 

Regards,

Kasyap

 

pgsql-bugs by date:

Previous
From: Andres Freund
Date:
Subject: Re: [BUG] Re-entering malloc problem when use --enable-nls buildpostgresql
Next
From: "David G. Johnston"
Date:
Subject: Re: Invalid precision for money datatype