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

2 votes295 views1 answer
How to add where command in update comand with joins
SQL
0 vote298 views1 answer
Drop all triggers oracle
SQL
1 vote282 views2 answers
Mysql update table from another table
SQL
0 vote362 views1 answer
Sql datum formatieren
SQL
1 vote331 views1 answer
Update from select oracle
SQL
0 vote312 views2 answers
Collation in sql
SQL
0 vote291 views1 answer
Getting next sequence value jpa postgress
SQL
1 vote330 views2 answers
Extract weekday from date in sql
SQL
8 votes294 views3 answers
Mysql alter table add index
SQL
1 vote346 views1 answer
Sql count value greater than
SQL