Skip site navigation (1) Skip section navigation (2)

numeric type

From: "Peter" <peter(at)greatnowhere(dot)com>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: numeric type
Date: 2008-07-20 10:32:51
Message-ID: 005b01c8ea53$f64a9fd0$e2dfdf70$@com (view raw, whole thread or download thread mbox)
Lists: pgsql-jdbc
For numeric types (with no explicit scale and precision) JDBC returns 0 for
both precision and scale (ResultSetMetaData.getPrecision and getScale
methods). This is breaking my app and IMO does not reflect true state of
things since Postgres docs state: "NUMERIC without any precision or scale
creates a column in which numeric values of any precision and scale can be
stored, up to the implementation limit on precision". 


Shouldn't PG JDBC driver return maximum possible values for precision and
scale in such cases? 





pgsql-jdbc by date

Next:From: Arun ViswanathanChandrikaDate: 2008-07-20 13:39:28
Subject: issue with select IN (?) query
Previous:From: Tom LaneDate: 2008-07-19 00:51:14
Subject: Re: Problem with java infinity mapping to postgres real column type

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group