id,summary,reporter,owner,description,type,status,priority,milestone,component,version,resolution,keywords,cc 884,"Unstable results with ST_Within, ST_Intersects",strk,chodgson,"This is pretty puzzling. Load attached dataset, then: (I suspect it affects all functions that used prepared geometry - does same with ST_Intersects) {{{ -- This query says none of the 3 polygons contain the point =# select gid, ST_Within( ST_GeomFromText('POINT (-115.04252 36.05137)', -1), the_geom ) from foo_reload; -- This query says polygon 3 does contain the point =# select gid, ST_Within( ST_GeomFromText('POINT (-115.04252 36.05137)', -1), the_geom ) from foo_reload where gid = 3; }}} Storing the point geometry into a table makes no difference. Geometry number 3 really contains the point. The other two don't. I've tested this with PostgreSQL 8.4.3, PostGIS 2.0.0SVN and GEOS 3.3.0dev",defect,closed,high,PostGIS 1.5.3,postgis,1.5.X,fixed,history,lreeder