Re: rounding_up

2025-04-15 Thread Daria Shanina
Hi, Christoph! You wrote a very interesting answer. > First question would be "which round rule?" I mean rounding up “as at school”, but there are nuances in programming. > https://www.postgresql.org/docs/current/functions-math.html Thanks a lot for the link to the doc! > you set it to with

Re: rounding_up

2025-04-15 Thread Daria Shanina
Hi, Tom! > Round-to-nearest-even is a well-respected rule Yes, you're convinced me! I can’t argue with IEEE 754 =) And, of course, can’t break compatibility. Best regards, Daria Shanina пн, 14 апр. 2025 г. в 17:26, Tom Lane : > Christoph Moench-Tegeder writes: > > ## Daria Shanina (vilensip

Re: rounding_up

2025-04-14 Thread Tom Lane
Christoph Moench-Tegeder writes: > ## Daria Shanina (vilensip...@gmail.com): >> I noticed, when we parse and validate values (in particular, the int type), >> we use the *rint* method, but unfortunately it does not work according to >> the round rules. > First question would be "which round rule?

Re: rounding_up

2025-04-14 Thread Christoph Moench-Tegeder
Hi, ## Daria Shanina (vilensip...@gmail.com): > I noticed, when we parse and validate values (in particular, the int type), > we use the *rint* method, but unfortunately it does not work according to > the round rules. First question would be "which round rule?" as (of course) there're multiple

Re: rounding_up

2025-04-14 Thread Andrey Borodin
Hi Daria! > On 14 Apr 2025, at 13:24, Daria Shanina wrote: > > when we parse and validate values (in particular, the int type), we use the > rint method, but unfortunately it does not work according to the round rules. Are this concerns explainable in SQL query? As far as I can see from your