I am running the below query and try to identify the end point of a line with gid 338 on the polygon's boundary with gid 1456 but got some error message:
SELECT public.st_contains((Select public.st_EndPoint(the_geom) from lines where gid=338),(select public.st_Boundary(the_geom) from polygons where gid=1456))
The error message:
> ERROR: function _st_contains(public.geometry, public.geometry) does
> not exist LINE 1: SELECT $1 && $2 AND _ST_Contains($1,$2)
> HINT: No function matches the given name and argument types. You might need to add explicit type casts.
> QUERY: SELECT $1 && $2 AND _ST_Contains($1,$2) CONTEXT: SQL function
> "st_contains" during inlining
If I run
SELECT ST_Contains(ST_GeomFromText('LINESTRING(0 0, 5 5, 10 10)'),ST_GeomFromText('point(3 3)'));
It will return "t" as the correct value.
ST_Contains()
, you can't call it using lower case letters e.g.st_contains
as far as I know.