Re: Explanation of the ROUND function with NUMERIC as an argument

2022-12-03 Thread hirokazu kamiya
Thank you for your answer. I am convinced. Thank you for replying to my question in poor English. 2022年12月3日(土) 23:19 Tom Lane : > Laurenz Albe writes: > > On Sat, 2022-12-03 at 08:54 +, PG Doc comments form wrote: > >> I am thinking that the value of the ROUND function with NUMERIC as an >

Re: Explanation of the ROUND function with NUMERIC as an argument

2022-12-03 Thread Tom Lane
Laurenz Albe writes: > On Sat, 2022-12-03 at 08:54 +, PG Doc comments form wrote: >> I am thinking that the value of the ROUND function with NUMERIC as an >> argument is rounded off, not rounded away from zero. > It is rounded away from zero, since 43 is farther away from 0 than 42.5. > This

Re: Explanation of the ROUND function with NUMERIC as an argument

2022-12-03 Thread Laurenz Albe
On Sat, 2022-12-03 at 08:54 +, PG Doc comments form wrote: > Explanation of the manual's ROUND function > round ( numeric ) → numeric > round ( double precision ) → double precision > Rounds to nearest integer. For numeric, ties are broken by rounding away > from zero. For double precision, the