postgres=# -- Valid floating-point values postgres=# postgres=# SELECT .04 AS small_float; small_float ------------- 0.04 (1 row)