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 vote351 views1 answer
Import Data in MySQL without using any other software
SQL
2 votes366 views1 answer
Find all triggers in database
SQL
1 vote332 views2 answers
Postgresql backup and restore globals and data
SQL
4 votes489 views6 answers
Laravel jwt
SQL
0 vote411 views3 answers
How to find all role in mysql
SQL
0 vote340 views1 answer
MQL4 mql4 run ea on all symbols by adding to just one chart
SQL
0 vote350 views1 answer
Sql count total by foreign key
SQL
20 votes406 views4 answers
Sql count if
SQL
0 vote330 views1 answer
Eliminar ultimo carcacter mysql
SQL
0 vote418 views1 answer
Mariadb change column type
SQL