ST_Within fails at walls (upright polygons)

[weitzig]

ST_Within doesn't find upright polygons.

Prepare example:

CREATE table walltest();
SELECT AddGeometryColumn('walltest', 'feature', -1, 'GEOMETRY', 3 );
INSERT INTO walltest(feature) VALUES ('POLYGON((1 0 5,2 0 5,2 0 10,1 0 10,1 0 5))');

Execute Example:

SELECT feature FROM walltest WHERE ST_Within(feature,'POLYGON((-5.0 -5.0 0.0,5.0 -5.0 0.0,5.0 5.0 0.0,-5.1 5.0 0.0,-5.0 -5.0 0.0))')='T'

The query should find the polygon, but it doesn't.

[strk]

ST_Within is 2d-only (all intersection matrix based are). Try ST_CoveredBy