Re: BUG #12053: Strange behavior for numeric types with unspecified precision-scale

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Tommaso Sala <tommaso(dot)sala(at)cla-it(dot)eu>
Cc: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #12053: Strange behavior for numeric types with unspecified precision-scale
Date: 2014-11-29 15:55:22
Message-ID: 11413.1417276522@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Tommaso Sala <tommaso(dot)sala(at)cla-it(dot)eu> writes:
> The strange fact is that if you try to write 0.000001, it gets displayed
> correctly

My guess is that the adapter miscomputes dscale in only some situations.

> I'd agree with your proposed solution, if I only set a dscale of 2.
> But I didn't.

You didn't, but the available evidence says that Devart's adapter did.

If you maintain there is some other bug involved, maybe I *should* make
numeric_recv throw an error, just so the blame gets placed clearly.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David G Johnston 2014-11-29 17:40:33 Re: BUG #12053: Strange behavior for numeric types with unspecified precision-scale
Previous Message Tommaso Sala 2014-11-29 12:12:39 Re: BUG #12053: Strange behavior for numeric types with unspecified precision-scale