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

0 vote126 views1 answer
Oracle last character of string
SQL
0 vote144 views1 answer
Unable to convert mysql date/time value to system.datetime
SQL
0 vote141 views1 answer
Sql remove first character from string
SQL
0 vote124 views1 answer
Install mysql for fedora 34
SQL
0 vote169 views1 answer
Wordpress make wp user in db
SQL
0 vote154 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL
6 votes171 views3 answers
Mysql change auto_increment start value
SQL
0 vote150 views1 answer
How to retrive the today date sql
SQL
0 vote122 views1 answer
Create new table pl sql
SQL
0 vote163 views1 answer
Ran rails db:migrate and got == 20210620104415 DeviseCreateUsers: migrating ================================ -- create_table(:users) rails aborted! StandardError: An error has occurred, this and all later migrations canceled: SQLite3::SQLE
SQL