PostgreSQL Conference Germany38 days until PGConf.DE 2026.
The precision for a NUMERIC type in some other databases can go up to 38. 10^38 fits into 128 bits.The precision for a NUMERIC type in PostgreSQL is up to 1000 for exact numbers.
caravantravellers 🌈That has been the case for ages. Does anybody know where this awkward number 38 stems from?
Andreas Scherbaum@caravantraveller @pgconfde 10^38 is 100000000000000000000000000000000000000 and fits into 2^128 (340282366920938463463374607431768211456, or 2^127 (signed), 170141183460469231731687303715884105728).
10^39 is already too large to fit into 128 bits.