数据类型

数字。

SELECT 123456789123456789123456789123456789 AS result;

result
123456789123456789123456789123456789

(1 row)

SELECT CAST('8.123456789' AS NUMERIC);

numeric
8.123456789

(1 row)

SELECT CAST('8.123456789' AS REAL);

float4
8.123457

(1 row)