4 ms·
In PostgreSQL, if you specify a decimal literal, it is assumed to be type NUMERIC (arbitrary precision) by default, as opposed to FLOAT or DOUBLE PRECISION. If
by zeroimpl 8y ago
In PostgreSQL, if you specify a decimal literal, it is assumed to be type NUMERIC (arbitrary precision) by default, as opposed to FLOAT or DOUBLE PRECISION.
If you stored your values in table rows as DOUBLE PRECISION, you would of course get the wrong answer.