et-string-to-numeric-conversion.md
String-to-numeric data type conversions accept formats of quoted constants for scientific notation, binary scaling, hexadecimal, and combinations of numeric-type literals:
-
Scientific notation
:
=> SELECT FLOAT '1e10'; ?column? ------------- 10000000000 (1 row)
-
BINARY
scaling:
=> SELECT NUMERIC '1p10'; ?column? ---------- 1024 (1 row)
-
hexadecimal:
=> SELECT NUMERIC '0x0abc'; ?column? ---------- 2748 (1 row)