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
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
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?
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
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