[postgis-users] HOWTO Identify a polygon object by point??

[David Blasby]

Düster Horst wrote:

The "&&" operator will select the polygons whose bounding box intersects the
point.  It indexed so its a very fast search.

If you want a better answer, use the distance() function.

SELECT number FROM parcels WHERE wkb_geometry && GeometryFromText('POINT(624000
245600)',-1) AND distance(wkb_geometry, GeometryFromText('POINT(624000
245600)',-1)) ==0;