| From: | SriRaghu Sai Kasyap <skasyap(at)opentext(dot)com> |
|---|---|
| To: | "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org> |
| Cc: | Siva Phani Kumar Kothuri <skothuri(at)opentext(dot)com> |
| Subject: | Invalid precision for money datatype |
| Date: | 2018-05-08 09:22:52 |
| Message-ID: | SN2PR15MB099251E27BA21B2E6655CF15DE9A0@SN2PR15MB0992.namprd15.prod.outlook.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2018-05-08 12:19:17 | Re: Invalid precision for money datatype |
| Previous Message | Andres Freund | 2018-05-08 08:36:31 | Re: [BUG] Re-entering malloc problem when use --enable-nls build postgresql |