postgres=#
postgres=#
postgres=# -- floor(x): Returns the largest whole integer not greater than x (rounds down)
postgres=# SELECT floor(1.0) AS one,
postgres-# floor(1.1) AS "one point one",
postgres-# floor(1.8) AS "one point eight";
one | one point one | one point eight
-----+---------------+-----------------
1 | 1 | 1
(1 row)
postgres=#