BUG #14786: Wrong Precision with money datatype

From: nithinkrishna(dot)p(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Cc: nithinkrishna(dot)p(at)gmail(dot)com
Subject: BUG #14786: Wrong Precision with money datatype
Date: 2017-08-21 08:04:01
Message-ID: 20170821080401.1458.12982@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 14786
Logged by: Nithin Krishna
Email address: nithinkrishna(dot)p(at)gmail(dot)com
PostgreSQL version: 9.4.5
Operating system: Windows 2008 R2 Standard Edition
Description:

Hi,

I have a table created in postgres database with money datatype. I have
connected to the database via SQuirrel SQL Client and found that the
precision of the money datatype is shown as 2147483647. But from the
postgres documentation the precision and scale should be 19 and 2
respectively. I am using postgres driver jar postgresql-9.4-1203.jdbc42.jar
and database version is 9.4.5

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message fadheljmuhammad 2017-08-21 09:08:11 BUG #14787: Postgresql_for_odoo
Previous Message David G. Johnston 2017-08-21 05:10:28 Re: json and jsonb bug report