79332512

Date: 2025-01-06 08:43:03
Score: 3
Natty:
Report link

The answer is : YES PostgreSQL round values.

Thanks to @vérace I can found it into the source code of PostgreSQL where the d2d function is used to output the decimal form of the value.

This is quite complicated but to simplify, a validity interval is calculated depending on the exponent and the mantissa. Then the decimal value is rounding in consistency to the validity interval.
The final result is rounded to about (really about) the value multiply by 10^-16.

This answer will be marked as "accepted" when I will be granted to ;-)

Reasons:
  • Blacklisted phrase (0.5): Thanks
  • Long answer (-0.5):
  • No code block (0.5):
  • User mentioned (1): @vérace
  • Self-answer (0.5):
  • Low reputation (1):
Posted by: Arthur Bazin