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

5 votes162 views3 answers
Sql server utc to local
SQL
0 vote143 views1 answer
MySQL error code 2068
SQL
0 vote154 views1 answer
Sql query to get contact form 7 fields
SQL
0 vote146 views1 answer
Mssql check if date is greater than today
SQL
0 vote134 views1 answer
Sql date between one week
SQL
1 vote156 views1 answer
Update from select oracle
SQL
1 vote157 views1 answer
Code: "ER_TRUNCATED_WRONG_VALUE", errno: 1292, sqlMessage: "Incorrect date value: '2021-03-20T18:30:00.000Z' for column 'mgfdate' at row 1", sqlState: "22007", index: 0, …}
SQL
1 vote175 views1 answer
Oracle schema size
SQL
0 vote183 views1 answer
Change mysql version to 5.7 in ubuntu
SQL
0 vote140 views2 answers
Pl sql auto increment
SQL