Home > mailing lists

double precisoin type - Mailing list pgsql-hackers

From	Fabrice Chapuis
Subject	double precisoin type
Date	March 1 17:46:45
Msg-id	CAA5-nLDB7ko9LNo270=pZ-jt+OfXsxjD0k52jMg-OS4Yxe-mUw@mail.gmail.com Whole thread Raw
Responses	Re: double precisoin type
List	pgsql-hackers

Hello,

postgres [1264904]=# select 123456789.123456789123456::double precision;

┌────────────────────┐

│ float8 │

├────────────────────┤

│ 123456789.12345679 │

└────────────────────┘

(1 row)

I do not understand why this number is truncated at 123456789.12345679 that is 17 digits and not 15 digits

Any idea

Fabrice

Documentation says:

double precision 8 bytes variable-precision, inexact 15 decimal digits precision

From: Bharath Rupireddy
Date: 01 March, 17:32:00
Subject: Re: Introduce XID age and inactive timeout based replication slot invalidation

From: Tomas Vondra
Date: 01 March, 17:58:38
Subject: Re: index prefetching