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

0 vote277 views2 answers
Influxdb delete measurement based on date
SQL
27 votes335 views5 answers
Mysql set password for user
SQL
0 vote320 views1 answer
Oracle current timestamp
SQL
0 vote353 views1 answer
Check if mysql db is used
SQL
1 vote294 views3 answers
Default password of mysql
SQL
0 vote318 views1 answer
Sql server separar numeros por comas miles
SQL
0 vote330 views1 answer
Select all same column value in sql
SQL
0 vote307 views1 answer
View to table
SQL
0 vote326 views1 answer
Raiserror with nowait
SQL
0 vote317 views1 answer
Sql Top 5 sutradara dengan filem terbanyak
SQL