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 votes187 views1 answer
Power query concatenate
SQL
0 vote246 views2 answers
Return the number of records in a single table mysql
SQL
5 votes178 views1 answer
Oracle get foreign keys on table
SQL
0 vote172 views1 answer
Adonisjs ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
3 votes166 views4 answers
Order by desc postgres
SQL
0 vote172 views1 answer
Sql select by content lenght
SQL
0 vote171 views1 answer
Delete double on SQL with multiple primary keys
SQL
0 vote173 views1 answer
T sql cursor tr
SQL
0 vote173 views1 answer
How to set all the min and sec data to zero in sql server
SQL
1 vote164 views2 answers
Mysql spring boot application.properties
SQL