geometry-expression.ST_GeometryType()

The ST_GeometryType method returns a string containing the specific type name of geometry-expression.

The value IS OF( type ) syntax can also be used to determined the specific type of a value.

The following returns the result 2,3,6,16,22,24,25, which is the list of ShapeIDs whose corresponding Shape is one of the specified types.

SELECT LIST( ShapeID ORDER BY ShapeID )
FROM SpatialShapes
WHERE Shape.ST_GeometryType() IN( 'ST_Polygon', 'ST_CurvePolygon' )