[postgis-users] Problem with functions contains

strk at refractions.net strk at refractions.net
Wed Oct 5 05:40:11 PDT 2005

I get the same results, but I can't "visually" see the non-containment.
I tried using qgis, but no displacement is shown between the two
boundaries until I zoom *really close* obtaining a rendering bug instead.
Can it be JUMP gets confused as well by too-small values ?


On Tue, Oct 04, 2005 at 06:09:57PM -0300, Miguel de la Fuente wrote:
> strk: I' have the following problem, when I use the function contains it
> returns true when the polygons is not totally contains.
> I have applied snaptogrid in my geometry column.
> I did the following :
> update table1 set new_geom=snaptogrid(the_geom,1e-2)
> update table2 set new_geom=snaptogrid(the_geom,1e-2))
> When I use the function contains()
>  select
> b.*
> from table2 b, table1 a
> where contains (b.new_geom,a.new_geom)
> it returns true,but I see visually that b not contains completely a.
>  I don't understand why??
>   I attach the data and a image showing the problem.
>  Thanks.

> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

More information about the postgis-users mailing list