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 vote200 views2 answers
Temp tables in sql server
SQL
1 vote176 views1 answer
Join first name and last name sql
SQL
1 vote193 views3 answers
How to pass password to mysql command line
SQL
0 vote184 views1 answer
How to generate ids in sql
SQL
1 vote172 views1 answer
Sql list all procedures
SQL
1 vote165 views1 answer
Sql convert month name to number
SQL
7 votes187 views3 answers
Postgresql dump and restore db
SQL
4 votes181 views1 answer
Mysql ip address data type
SQL
11 votes191 views6 answers
Mysql else if
SQL
1 vote168 views1 answer
Mysql column start with string
SQL