Postgres Pro
Downloads
Home   >   mailing lists

Re: BigDecimal instead of Integer in 7.1 - Mailing list pgsql-jdbc

From Tom Lane
Subject Re: BigDecimal instead of Integer in 7.1
Date
Msg-id 1948.988684856@sss.pgh.pa.us
Whole thread Raw
In response to BigDecimal instead of Integer in 7.1  (Joseph Shraibman <jks@selectacast.net>)
List pgsql-jdbc
Tree view 
Joseph Shraibman <jks@selectacast.net> writes:
> The problem is suddenly in 7.1 the result of the subselect used to
> return an Integer now returns a BigInteger and is causing
> classCastExceptions in my code.  What gives?

sum() and avg() return NUMERIC now for integer input, to avoid
overflow and precision problems.

            regards, tom lane

pgsql-jdbc by date:

Previous
From: Joseph Shraibman
Date:
Subject: BigDecimal instead of Integer in 7.1
Next
From: Joseph Shraibman
Date:
Subject: Vectors in 7.1 ResultSets