Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group