Tom Lane wrote:
>
> Joseph Shraibman <[EMAIL PROTECTED]> 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
[EMAIL PROTECTED]
Increase signal to noise ratio. http://www.targabot.com
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
