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 votes178 views1 answer
Add new column not null sql server
SQL
3 votes167 views1 answer
Postgresql db owner change
SQL
0 vote170 views1 answer
Power bi dax add related shows column but not working
SQL
1 vote166 views1 answer
Get last week data in mysql
SQL
9 votes191 views6 answers
Oracle substring
SQL
3 votes145 views1 answer
Oracle failed login attempts
SQL
0 vote292 views1 answer
Oracle convert int to date
SQL
0 vote167 views1 answer
Mysql workbench download for iinux mint 19.3
SQL
38 votes233 views6 answers
Alter table mysql
SQL
28 votes169 views6 answers
Sql update
SQL