[postgis-devel] Should EMPTY be spatially equal to self ?
Paragon Corporation
lr at pcorp.us
Thu Jan 19 04:43:56 PST 2012
> Pretty much. Internally, the predicates do use DE9IM, except
> for some optimizations implemented _before_ computing the
> whole intersection matrix. Optimizations currently include
> bounding box comparosons.
>
> > FFF.FFF.FF2 is a sensible DE9IM matrix for empty - empty in set
> > theoretical terms, but does it make sense to apply it for spatial
> > predicates? Many say yes, some say no.
>
> I don't think anyone is suggesting NOT to use the matrix in
> spatial predicates. I think what I'm suggesting to change the
> definition of ST_Equals in matrix terms, or to introduce an
> explicit corner case for the EMPTY case.
>
> --strk;
>
I had one of my Oracle firends test and his response.
"This is what Oracle has:
SELECT
ST_Geometry.ST_Point(0,0,NULL).ST_Equals(ST_Geometry.ST_Point(0,0,NULL)) as
testequals
FROM dual;
TESTEQUALS
----------
1
That is, TRUE. as it should be."
At this point I don't really care strk. I'm tired of arguing about it. So
I will vote:
0-
I'm still not clear the benefit of changing and would rather not bother if
there is no benefit.
Thanks,
Regina
More information about the postgis-devel
mailing list