Re: BigDecimal instead of Integer in 7.1

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Joseph Shraibman <jks(at)selectacast(dot)net>
Cc: "'pgsql-jdbc(at)postgresql(dot)org'" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: BigDecimal instead of Integer in 7.1
Date: 2001-05-01 02:40:56
Message-ID: 1948.988684856@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Joseph Shraibman <jks(at)selectacast(dot)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

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Joseph Shraibman 2001-05-01 02:42:53 Vectors in 7.1 ResultSets
Previous Message Joseph Shraibman 2001-05-01 02:35:12 BigDecimal instead of Integer in 7.1