[BUGS] BUG #14786: Wrong Precision with money datatype - Mailing list pgsql-bugs

From nithinkrishna.p@gmail.com
Subject [BUGS] BUG #14786: Wrong Precision with money datatype
Date
Msg-id 20170821080401.1458.12982@wrigleys.postgresql.org
Whole thread Raw
Responses Re: [BUGS] BUG #14786: Wrong Precision with money datatype  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: [BUGS] BUG #14786: Wrong Precision with money datatype  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      14786
Logged by:          Nithin Krishna
Email address:      nithinkrishna.p@gmail.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


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

pgsql-bugs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: [BUGS] json and jsonb bug report
Next
From: fadheljmuhammad@gmail.com
Date:
Subject: [BUGS] BUG #14787: Postgresql_for_odoo