I have tried it with the point and geometry reversed with the same result.
Perhaps, I am not looking at this the right way.
According to the manual
st_within Returns TRUE if geometry A (points) is completely inside geometry
B ( geometry).
If it scans the list of 858 points some of those points are within the
geometry - unless Postgis is looking at the 858 points as one entity.
Bob
----- Original Message -----
From: "Maxime van Noppen" <[email protected]>
To: "PostGIS Users Discussion" <[email protected]>
Sent: Monday, October 19, 2009 8:50 AM
Subject: Re: [postgis-users] St_within problem
Bob Pawley wrote:
select st_astext(graphics.point_grid.the_geom)
from graphics.point_grid, library.dgm_process
where library.dgm_process.process_number = '1'
and st_within(graphics.point_grid.the_geom,
library.dgm_process.the_geom);
Any thoughts would be appreciated.
Hi,
From the documentation here :
http://postgis.refractions.net/documentation/manual-1.4/ST_Within.html
boolean ST_Within(geometry A, geometry B);
Returns TRUE if geometry A is completely inside geometry B.
I suggest that you just swap the arguments of the ST_Within function as
a geometry will never be "completly inside" a point.
--
Maxime
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
