I have a table with more than 10 million rows in a postgresql database. In the table two columns are of type numeric(12,8) and contains lat lon of the locations. But in more than thousand rows values are empty.
I want to retrieve that rows that have empty lat lon but I am not able to create a query for that as in character varying columns we retrieve that rows with '' value, but this time the data type is different. I checked the below commands but all fails :-
select * from table where lat =''; ---- error select * from table where lat <=0;----- no rows
Please guide me if there is a proper query for that.
