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