MI_Difference

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.