How to store decimal numbers in Postgresql database?

The issue is just visual - but it will be fixed in the next update. Now the decimal type will be diaplyed correctly.

1 Like

Are you sure it’s only cosmetic? Because when viewing my table in the database manager I can see the numbers are being rounded up. Same for when I use data from sever connect inside a repeat. I can’t check heroku database visually to confirm the output.

Well if you apply any changes to that field afterwards it might have being changed to integer.

Best to check its native type straight in the database with tools like pgadmin

Hey thanks for fixing this, now my decimal type in shown correctly in the properties & saving correctly but when I view the field in the database manager I still see just integers.

I save 2.2 it will display as 2 in the database manager but display correctly when used from server connect query in a repeat.

You mean when using the view/edit data from the context menu? Then it is incorrect in the grid?

But otherwise well stored in the database and working fine on the site?

Yes that’s what I mean.