Re: BigDecimal instead of Integer in 7.1

Tom Lane wrote:
>
> 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


My second count (not in the subquery) is returning an Integer.
--
Joseph Shraibman
jks@selectacast.net
Increase signal to noise ratio.  http://www.targabot.com