Re: Possible 7.1RC1 bug

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Possible 7.1RC1 bug
Date: 2001-03-30 17:37:31
Message-ID: web-31925@davinci.ethosmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Tom,

> This is not a bug. It's a deliberate change in behavior: sum() and
> avg() on integer datatypes now return numeric, to avoid problems with
> overflow.

That could throw off some of my already-written views & functions. Is
there a setting that can change this back to the "regular" behavior of
sum(integer) = integer?

-Josh Berkus

______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Mikheev, Vadim 2001-03-30 18:54:48 RE: [HACKERS] Re: possible row locking bug in 7.0.3 & 7.1
Previous Message Peter Eisentraut 2001-03-30 16:18:52 Re: primary key scans in sequence