Now I have point geometry of latitude and longitude value, say 23.4877191,86.6927571, I want to find all the geometries which are within a distance of 1000 meters from this given point. I tried the following query:
select locationid from cartlocations where ST_DWithin(ST_GeomFromText('POINT(23.4877191 86.6927571)'),location,1000);
But I was getting this error-
HINT: No function matches the given name and argument types. You might need to add explicit type casts.