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

-2 votes204 views1 answer
Trunc in sql
SQL
6 votes159 views4 answers
Rror: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote204 views1 answer
How to compile a function in oracle
SQL
0 vote186 views1 answer
How to check database engine in mysql
SQL
1 vote145 views2 answers
How to check username in mysql command line
SQL
2 votes173 views1 answer
Query to find table size in oracle 12c
SQL
8 votes121 views1 answer
Oracle current date plus 1 month
SQL
2 votes196 views1 answer
Orcale index size
SQL
7 votes146 views1 answer
Sql server convert string to date
SQL
2 votes108 views1 answer
Sql group by different columns
SQL