I'm trying to run this query to change my latitude coordinates, which is saved as text into a double precision
ALTER TABLE mapdata ALTER COLUMN lat TYPE double precision USING (lat::double precision);
However, I keep getting this error:
invalid input syntax for type double precision: ""
My assumption is that there is a blank entry and that postgres doesn't know to treat it as a double precision. How would I make this out to be a
NULL or is there another way I can approach this to turn my
lat column into a
double precision? Thanks!