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>