Postgresql float data type

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 vote183 views1 answer
Generate sequence number in sql server
SQL
0 vote223 views1 answer
ALV GRID events
SQL
0 vote232 views1 answer
Create dabase postgresql
SQL
0 vote193 views3 answers
Sql query checker
SQL
0 vote203 views1 answer
Sql select sum group by id laravel join
SQL
0 vote292 views1 answer
Placements hackerrank solution
SQL
3 votes181 views3 answers
Remove all spaces from string sql
SQL
0 vote325 views2 answers
Https://cloud.google.com/shell/docs/using-web-preview#previewing_the_application
SQL
0 vote206 views1 answer
Mysql export data with a where clause
SQL
0 vote174 views1 answer
Mysql add comment to column
SQL