[postgis-users] Return row from point

[Kevin Neufeld]

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
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users