Re: Possible 7.1RC1 bug - Mailing list pgsql-sql

From Josh Berkus
Subject Re: Possible 7.1RC1 bug
Date
Msg-id web-31925@davinci.ethosmedia.com
Whole thread Raw
In response to Re: Possible 7.1RC1 bug  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Possible 7.1RC1 bug
List 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
informationtechnology      josh@agliodbs.com  and data management solutions       (415) 565-7293 for law firms, small
businesses       fax 621-2533   and non-profit organizations.      San Francisco
 


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Possible 7.1RC1 bug
Next
From: Tim Perdue
Date:
Subject: Vacuum Error