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

1 vote233 views1 answer
Mysql get character set
SQL
0 vote254 views1 answer
Store case result sql
SQL
0 vote228 views1 answer
Mysql jdbc timezone
SQL
0 vote246 views5 answers
Mode sql course
SQL
1 vote233 views2 answers
Sql left characters
SQL
1 vote267 views1 answer
Mysql update inner
SQL
15 votes243 views6 answers
Drop foreign key mysql
SQL
0 vote240 views1 answer
Create table with float datatype in sql server
SQL
16 votes232 views3 answers
Delete row psql
SQL
18 votes232 views6 answers
Drop table if exists
SQL