Apex offers the ‘number’ data type, but not specifically double, or point (postgres).
What would you recommend for storing longitude and latitude values?
“number” is a JavaScript / TypeScript value. By default, a number property is given an integer column type in Postgres. You can change the column type to whatever you want for the underlying storage.
Claude suggests using a NUMERIC(10, 7) representation which gives accuracy to 1 cm which is pretty good ;).
I tried Numeric(10,7) and Point (a postgres datatype), but the form won’t take it.
Did you mean that you have to use Number from the UI perspective (javascript/typescript) and manually set the underlying datatype in the db direct?
