| From: | pistole(at)rhp(dot)org |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #14663: Unexpected rounding changes for money type divided by bigint |
| Date: | 2017-05-19 16:46:53 |
| Message-ID: | 20170519164653.29941.19098@wrigleys.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 14663
Logged by: Richard Pistole
Email address: pistole(at)rhp(dot)org
PostgreSQL version: 10beta1
Operating system: Centos 7
Description:
Running the following query:
select 878.08::money/11::bigint;
Returns this following result in 9.6.3:
$79.83
In 10beta1, it returns:
$79.82
I think this may be related to this commit and doing the running sums as
negatives, but I'm not sure:
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2017-05-19 17:02:47 | Re: BUG #14662: 'has_table_privilege()' function fails with error, "invalid name syntax" when using Japanese symbols |
| Previous Message | jmuise | 2017-05-19 16:23:16 | BUG #14662: 'has_table_privilege()' function fails with error, "invalid name syntax" when using Japanese symbols |