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 vote283 views1 answer
Sql list dates between two dates
SQL
1 vote289 views2 answers
Group_concat limit mysql
SQL
0 vote308 views1 answer
Sql quary intervewi question
SQL
0 vote332 views1 answer
Pgadmin postgres ERROR: database is being accessed by other users
SQL
0 vote226 views2 answers
Illuminate\Database\QueryExceptionSQLSTATE[HY000] [2002] No such file or directory
SQL
0 vote257 views1 answer
Install mysql 8 linux
SQL
14 votes294 views3 answers
Inner join sql oracle
SQL
0 vote267 views1 answer
Oracle get running queries
SQL
0 vote299 views1 answer
Copy row from db to db mysql
SQL
1 vote278 views1 answer
Sql run multiple updates in one query
SQL