[postgis-users] Intersects with empty boxes error

[strk at refractions.net]

On Tue, Jan 25, 2005 at 05:13:22PM +0100, Daniel FAIVRE wrote:
> Hello,
> 
> With a code developped for previous versions, I've used to test 
> intersections, within, or contains with "point  boxes": like this:
> 
> 1) SELECT intersects(geometryfromtext('BOX3D(10 10, 10 10)', -1), 
> geometryfromtext('BOX3D(0 0, 20 20)', -1))
> 
> A true result is expected, like for:
> 
> 2) SELECT intersects(geometryfromtext('BOX3D(10 10, 10 10)', -1), 
> geometryfromtext('BOX3D(0 0, 20 20)', -1))
> 
> My new version is:
> POSTGIS=0.9.1 GEOS=2.1.1 PROJ=Rel. 4.4.7, 31 March 2003 USE_STATS 
> DBPROC=0.0.1 RELPROC=0.0.1
> The old one was a postgis 0.8.1 with GEOS 1.0
> 
> It has worked before, but now, request 1 return a false result. Is it a 
> known bug ?

Your BOX3D is not a valid GEOS geometry (collapses to a POINT).
You can't expect operations on non-valid geoms to return valid results.

--strk;

> 
> Sincerely yours,
> 
> Daniel FAIVRE
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users