round(4.0, 4) : Cast « Data Type « PostgreSQL






round(4.0, 4)



postgres=# SELECT round(4.0, 4);
 round
--------
 4.0000
(1 row)

postgres=#
           
       








Related examples in the same category

1.round(CAST (4 AS numeric), 4)
2.SELECT 1 + ('1' || '2')::integer
3.Cast char as integer