Float postgres

CREATE TABLE float_point (floatn FLOAT4); 	      -- precision min 4, maximum 8
INSERT INTO float_point (floatn) VALUES (543.23); -- 543,23
CREATE TABLE float_point_r (real_no REAL); 		  -- 1E-37 to 1E+37, 6 decimal max
INSERT INTO float_point_r (real_no) VALUES (12345623); -- 1,234562€+07

Source: educba.com

Postgresql float data type

ALTER TABLE tableName 
ADD COLUMN columnName float(4);

Similar codes

2 votes184 views1 answer
Postgresql update sequence next value
SQL
0 vote210 views2 answers
Transaction php
SQL
6 votes201 views2 answers
Oracle trigger
SQL
1 vote201 views1 answer
How to set up a trigger in sql
SQL
1 vote147 views1 answer
Enable mysql slow query log
SQL
3 votes185 views1 answer
Oracle user quota unlimited
SQL
0 vote199 views1 answer
Geopoint from json mysql function
SQL
1 vote208 views1 answer
Error:Got a packet bigger than 'max_allowed_packet' bytes
SQL
0 vote181 views1 answer
Find how many table doesn't contain column in mysql
SQL
4 votes233 views1 answer
Rename stored procedure in sql server
SQL