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 votes96 views2 answers
Mysql user access to database
SQL
0 vote94 views1 answer
User defined variables in sql
SQL
0 vote117 views2 answers
Mysql dump structure only
SQL
0 vote126 views1 answer
Sql_inner_join
SQL
-1 vote103 views1 answer
Mysql select count if contains
SQL
1 vote111 views1 answer
Check if mysql is installed
SQL
0 vote104 views1 answer
Mysql find db contarint
SQL
1 vote111 views1 answer
Mysql add fields
SQL
1 vote89 views2 answers
DROP TABLes regardless of constraints
SQL
0 vote108 views1 answer
Datagrip execute procedure
SQL