round(CAST (4 AS numeric), 4) : Cast « Data Type « PostgreSQL






round(CAST (4 AS numeric), 4)

postgres=# SELECT round(CAST (4 AS numeric), 4);
 round
--------
 4.0000
(1 row)

postgres=#

           
       








Related examples in the same category

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