Description
Calculates the difference between two geometries.
Syntax
MI_Difference ( geom1, geom2 )
Arguments
geom1 is a geometry object or an expression which returns a geometry,
geom2 is a geometry object or an expression which returns a geometry,
Example
Determines if there is a difference between a box and a state geometry.
select State_Name, MI_Difference(Obj,MI_Box(-106.709575,42.84867,-108.709575,44.416358,'EPSG:4326')) from usa where state='WY'
Remarks
Returns the difference between geom1 and geom2. If either geom1 or geom2 is null, MI_Difference returns null.