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 vote252 views1 answer
Sql query for getting data with join and count
SQL
0 vote249 views1 answer
Stop psql server windows
SQL
0 vote272 views1 answer
Mysql root permission denied lost
SQL
3 votes259 views2 answers
Oracle apex charging debug
SQL
0 vote296 views1 answer
Mysql faster delete
SQL
0 vote271 views1 answer
Warning: pdostatement::execute(): sqlstate[hy093]: invalid parameter number: number of bound variables does not match number of tokens
SQL
2 votes254 views1 answer
Alter table add multiple columns postgresql
SQL
1 vote254 views1 answer
Mysql2::Error: Incorrect string value: '\xE2\x80\x8B
SQL
1 vote253 views1 answer
Sql drop with dependencies
SQL
0 vote279 views1 answer
Lost connection to mysql
SQL