Re: Possible 7.1RC1 bug

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Kyle <kyle(at)actarg(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Possible 7.1RC1 bug
Date: 2001-03-30 15:33:36
Message-ID: 1088.985966416@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Kyle <kyle(at)actarg(dot)com> writes:
> It appears that sum(int4) returns type numeric. Shouldn't it return
> int4?

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.

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bruce Momjian 2001-03-30 15:52:52 Re: [SQL] Re: pg_dump potential bug -UNIQUE INDEX on PG_SHADOW Dont!! HELP
Previous Message Daniel Wickstrom 2001-03-30 15:15:43 Help with 'now', now(), timestamp 'now', ...