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 vote163 views1 answer
Oracle current date minus 1 day
SQL
9 votes153 views2 answers
Mac mysql this is incompatible with sql_mode=only_full_group_by
SQL
0 vote163 views1 answer
Hour differeence in mysql
SQL
1 vote132 views1 answer
Ilike for date postgres
SQL
5 votes164 views1 answer
Oracle sysdate - 1 month
SQL
3 votes132 views1 answer
Uppercase and lowercase in sql
SQL
0 vote276 views1 answer
Why do we need data structure in sql
SQL
8 votes159 views1 answer
Mysql restore database
SQL
0 vote164 views1 answer
Sqlite unique multiple columns
SQL
7 votes142 views2 answers
Create index mysql
SQL