I was trying to get the nearest people from mover_location table using the query as follows :
select * from mover_location where
public.st_dwithin(public.st_geogfromtext('SRID=4326;POINT(11.2565999 75.7711587)'),
last_seen_location_geog, 1060)
Which is not working and give me error like as follows :
ERROR: function _st_expand(public.geography, double precision) does not exist
and i didnt called the st_expand function , How can i resolve this ,Or is there any other
workarounds ? thanks .
My mover_location table structure is as follows ,here last_seen_location_geog is of geography type
UPDATE :-
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
QUERY: SELECT $1 && _ST_Expand($2,$3) AND $2 && _ST_Expand($1,$3) AND _ST_DWithin($1, $2, $3, true)
CONTEXT: SQL function "st_dwithin" during inlining
Add public schema to your search_path:
set search_path to your_schema, public;