BigDecimal instead of Integer in 7.1

From: Joseph Shraibman <jks(at)selectacast(dot)net>
To: "'pgsql-jdbc(at)postgresql(dot)org'" <pgsql-jdbc(at)postgresql(dot)org>
Subject: BigDecimal instead of Integer in 7.1
Date: 2001-05-01 02:35:12
Message-ID: 3AEE20E0.C165C94B@selectacast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

I just upgraded from 7.0.3 to 7.1.

I have a query like this:
SELECT l, (SELECT COUNT(*) FROM ms WHERE ms.p = 4 AND ms.s = 2),
COUNT(DISTINCT m.uid), COUNT(m.oid), AVG(m.msgs::int), SUM(m.msgs::int)
FROM m, a WHERE key = 4 AND m.p = 4 GROUP BY l;

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?

--
Joseph Shraibman
jks(at)selectacast(dot)net
Increase signal to noise ratio. http://www.targabot.com

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Tom Lane 2001-05-01 02:40:56 Re: BigDecimal instead of Integer in 7.1
Previous Message Ned Wolpert 2001-04-30 20:19:38 Re: JDBC Pooling driver