On Wednesday, October 18, 2023, 毛毛 <kr...@163.com> wrote: > > > I consulted the following doc and found that the range of real type is 6 > decimal digits precision. > https://www.postgresql.org/docs/current/datatype-numeric. > html#DATATYPE-NUMERIC >
You also need to consult: https://www.postgresql.org/docs/current/datatype-numeric.html#DATATYPE-FLOAT But in short, no, the result is input specific and you the user are not expected to know or care about such details. The docs say you will get between 6 and 9 digits depending on the value, under default settings. The table gives the minimum as clarified in the prose. There is room in the table to include more detail and it probably should. David J.
