15.10 - ST_SymDifference - Teradata Database

Returns an ST_Geometry value that represents the point set symmetric difference of two ST_Geometry values.

Argument …	Specifies …
ageometry	the other ST_Geometry value.

The type that the ST_Geometry return type represents is one from the possible set of types in the following table, depending on the parameter types.

∪ ( b — a )		∅	ST_Point	ST_LineString, GeoSequence	ST_Polygon		ST_MultiPoint	ST_MultiLineString	ST_MultiPolygon
∅		∅	R01	R02	R03		R04	R05	R06
ST_Point		R01	R10	R15	R22		R10	R17	R19
ST_LineString, GeoSequence		R02	R15	R08	R21		R15	R08	R18
ST_Polygon		R03	R22	R21	R14		R22	R21	R14
ST_MultiPoint		R04	R10	R15	R22		R10	R17	R19
ST_MultiLineString		R05	R17	R08	R21		R17	R08	R18
ST_MultiPolygon		R06	R19	R18	R14		R19	R18	R14

where: R01 = R02 = R03 = R04 = R05 = R06 = R08 = R10 = R14 = R15 =

ST_Point ST_LineString ST_Polygon ST_MultiPoint ST_MultiLineString ST_MultiPolygon ∅, ST_LineString, ST_MultiLineString ∅, ST_MultiPoint ∅, ST_Polygon, ST_MultiPolygon ST_LineString, ST_GeomCollection of ST_Point and ST_LineString values

R17 = R18 = R19 = R21 = R22 =

ST_MultiLineString, ST_GeomCollection of ST_Point and ST_LineString values ST_MultiPolygon, ST_GeomCollection of ST_LineString and ST_Polygon values ST_MultiPolygon, ST_GeomCollection of ST_Point and ST_Polygon values ST_Polygon, ST_GeomCollection of ST_LineString and ST_Polygon values ST_Polygon, ST_GeomCollection of ST_Point and ST_Polygon values

Teradata Database converts GeoSequence types that are involved in the ST_SymDifference method to ST_LineString values. Therefore, ST_SymDifference never returns a GeoSequence type.

All ST_Geometry types except geometry collections.

Note: This method can be called on 3D geometries (those that include z coordinates). However, the z coordinate is ignored in method calculations. Consequently, any z coordinates returned by this method should be ignored. Teradata recommends using the Make_2D method to strip out the z coordinates of the return value.

   SELECT shape.ST_SymDifference(

      NEW ST_Geometry('LINESTRING(2 2, 3 2, 4 1)'))

   FROM sample_shapes

   WHERE skey = 1067;