Patches for various NUMERIC bugs posted on pgsql-patches

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-sql(at)postgreSQL(dot)org
Subject: Patches for various NUMERIC bugs posted on pgsql-patches
Date: 2000-01-16 01:07:37
Message-ID: 17157.947984857@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I dug into the various reports of NUMERIC/DECIMAL bugs today,
and found that there were several different bugs lurking there.
If you are interested in having fixes to these problems before 7.0
comes out, see the patches I posted on the pgsql-patches list.

Problems fixed:

* Platform-dependent failure of NUMERIC AVG() function.
* Bogus rounding/overflow check would cause zero to be rejected
in a field that has only fraction digits, e.g. DECIMAL(4,4).
* numeric_out's rounding code could actually cause a coredump in
pathological cases (hasn't been reported from the field, though).
* NUMERIC basically didn't work at all in PL/PGSQL functions; on most
platforms you'd get bogus "overflow" errors.

regards, tom lane

Browse pgsql-sql by date

  From Date Subject
Next Message Egon Rothenberger 2000-01-16 12:51:08
Previous Message Michal Frajt 2000-01-15 11:19:43 (no subject)