PostgreSQL/Data Type/Float
select -16.63 AS negative_float
postgres=# select -16.63 AS negative_float;
negative_float
----------------
-16.63
(1 row)
Valid floating-point values
postgres=# -- Valid floating-point values
postgres=#
postgres=# SELECT .04 AS small_float;
small_float
-------------
0.04
(1 row)