Returns an ST_Geometry type where the representation is one of the possible set of types in the following table, depending on the parameter types.
| a — b | Ø | ST_Point | ST_LineString, GeoSequence | ST_Polygon | ST_MultiPoint | ST_MultiLineString | ST_MultiPolygon |
|---|---|---|---|---|---|---|---|
| Ø | Ø | Ø | Ø | Ø | Ø | Ø | Ø |
| ST_Point | R01 | R09 | R09 | R09 | R09 | R09 | R09 |
| ST_LineString, GeoSequence | R02 | R02 | R08 | R08 | R02 | R08 | R08 |
| ST_Polygon | R03 | R03 | R03 | R14 | R14 | R14 | R14 |
| ST_MultiPoint | R04 | R13 | R13 | R13 | R13 | R13 | R13 |
| ST_MultiLineString | R05 | R05 | R08 | R08 | R05 | R08 | R08 |
| ST_MultiPolygon | R06 | R06 | R06 | R14 | R06 | R05 | R06 |
Where:
|
|
Teradata Database converts GeoSequence types that are involved in the ST_Difference method to ST_LineString values. Therefore, ST_Difference never returns a GeoSequence type.