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

-1 vote122 views2 answers
First letter capital in mysql query
SQL
3 votes112 views4 answers
Stop MySQL
SQL
9 votes107 views2 answers
Sql limit to 5 results
SQL
34 votes112 views5 answers
Oracle alter table add column
SQL
0 vote113 views1 answer
Mysql remove tabs from string
SQL
0 vote172 views1 answer
Radius search with point data in mysql
SQL
3 votes113 views4 answers
Psql list tables in schema
SQL
2 votes114 views2 answers
Exec procedure pl sql
SQL
0 vote140 views1 answer
Sql delete caracter list
SQL
6 votes116 views1 answer
Oracle trigger after logon on schema
SQL