Re: [GENERAL] Rounding Double Precision or Numeric

2017-06-01 Thread Louis Battuello
> On Jun 1, 2017, at 12:58 PM, Scott Marlowe wrote: > > On Thu, Jun 1, 2017 at 10:42 AM, Steve Atkins > wrote: >> >>> On Jun 1, 2017, at 9:26 AM, Louis Battuello >>> wrote: >>> >>> Is the round() function implemented differently for double precision than >>> for n

Re: [GENERAL] Rounding Double Precision or Numeric

2017-06-01 Thread Scott Marlowe
On Thu, Jun 1, 2017 at 10:42 AM, Steve Atkins wrote: > >> On Jun 1, 2017, at 9:26 AM, Louis Battuello >> wrote: >> >> Is the round() function implemented differently for double precision than >> for numeric? Forgive me if this exists somewhere in the documentation, but I >> can't seem to find

Re: [GENERAL] Rounding Double Precision or Numeric

2017-06-01 Thread Steve Atkins
> On Jun 1, 2017, at 9:26 AM, Louis Battuello > wrote: > > Is the round() function implemented differently for double precision than for > numeric? Forgive me if this exists somewhere in the documentation, but I > can't seem to find it. https://www.postgresql.org/docs/current/static/datatype

Re: [GENERAL] Rounding Double Precision or Numeric

2017-06-01 Thread Torsten Förtsch
This is documented in section 8.1.2 in the manual. ( https://www.postgresql.org/docs/9.6/static/datatype-numeric.html) NUMERIC rounds away from zero. IEEE 754 based data types (FLOAT, DOUBLE PRECISION) round to the closest even number. On Thu, Jun 1, 2017 at 6:26 PM, Louis Battuello wrote: > I