[postgis-devel] Should EMPTY be spatially equal to self ?

Sandro Santilli strk at keybit.net
Fri Jan 13 03:48:05 PST 2012


On Fri, Jan 13, 2012 at 11:01:21AM +0100, Havard Tveite wrote:
> 1) ST_Equals can be used as a spatial join predicate.
> 2) An empty geometry has no location.
> 
> Therefore, I think that ST_Equals(empty,empty) should
> not return true and not return false, but NULL.
> What would be the consequences of that?

Do you really use ST_Equals as a join predicate ?
It'd be pretty overkill.

--strk; 

  ()   Free GIS & Flash consultant/developer
  /\   http://strk.keybit.net/services.html



More information about the postgis-devel mailing list