Try ST_Intersects.
http://postgis.refractions.net/documentation/manual-svn/ST_Intersects.html
SELECT *
FROM my_spatial_table
WHERE ST_Intersects(
the_geom,
ST_SetSrid(ST_MakePoint(1107983 739378), 2927)
);
Gady Pitaru wrote:
Is there a function I can use that will return the corresponding row
values of the geometry that intersects a passed in point? So if I pass
in the X, Y, and WKID or SRID, the function will hand back the row(s)
from the database that have geometry that intersect that point. Any help
is much appreciated.
Thanks,
Gady
------------------------------------------------------------------------
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
