Re: rounding_up

From: Andrey Borodin <x4mmm(at)yandex-team(dot)ru>
To: Daria Shanina <vilensipkdm(at)gmail(dot)com>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: rounding_up
Date: 2025-04-14 10:17:50
Message-ID: E4600155-847A-4E05-9BAF-21A0011682AB@yandex-team.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Daria!

> On 14 Apr 2025, at 13:24, Daria Shanina <vilensipkdm(at)gmail(dot)com> 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 data, rint() is consistent across OSes. Can user observe any inconsistency caused by rint() behavior in PostgreSQL?

Thanks!

Best regards, Andrey Borodin.

In response to

  • rounding_up at 2025-04-14 08:24:20 from Daria Shanina

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrey Borodin 2025-04-14 10:18:41 Re: New committer: Jacob Champion
Previous Message vignesh C 2025-04-14 09:34:57 Re: Logical Replication of sequences