Re: nextval parameter is not clear

2022-12-03 Thread Kirk Wolak
On Thu, Dec 1, 2022 at 4:21 PM Laurenz Albe wrote: > On Tue, 2022-11-29 at 16:26 -0500, Kirk Wolak wrote: > > On Mon, Nov 28, 2022 at 12:45 AM Tom Lane wrote: > > > Laurenz Albe writes: > > > > Now I think that is taking it too far. Your code sample would be > great > > > > for a tutorial,

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,

Explanation of the ROUND function with NUMERIC as an argument

2022-12-03 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/bug-reporting.html Description: I think the manual's description of the round function with numeric as an argument is different from the actual behavior. manual