Issue
Numeric datatype doesn't accept decimal points in numbers and PgAdmin 4.2 don't have decimal data type. I want to add percentage numbers like 4.8 and latitude, longitudes something like -89.03177649999999 this. Which is the best data type in postgresql for this king of numbers. PgAdmin only allows numeric datatype to use for numbers. If I add this numbers with numeric data type it throws errors.
Solution
You can absolutely insert values with a decimal point into a numeric column:
create table data (nr decimal);
insert into data
values
(-89.03177649999999);
Online example: https://rextester.com/VQB54123
Answered By - a_horse_with_no_name Answer Checked By - David Marino (PHPFixing Volunteer)
0 Comments:
Post a Comment
Note: Only a member of this blog may post a comment.