Re: BigDecimal instead of Integer in 7.1

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