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

1 vote350 views1 answer
Psql import backup file for windows
SQL
18 votes302 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
SQL
0 vote328 views2 answers
Nested query
SQL
12 votes358 views4 answers
How to check mysql version ubuntu
SQL
2 votes332 views6 answers
In operator in sql
SQL
0 vote335 views1 answer
Database xml sql
SQL
0 vote340 views1 answer
Get who is hired in february in sql
SQL
0 vote327 views1 answer
Ignore case in string sql
SQL
2 votes353 views1 answer
Q operator in plsql
SQL
4 votes391 views4 answers
Mysql get date from datetime
SQL