Returns the area measurement of an ST_Polygon or ST_MultiPolygon. For ST_MultiPolygon, returns the sum of the area measurements of the component polygons.
Returns a FLOAT value.
ST_Polygon and ST_MultiPolygon
CREATE TABLE sample_shapes (skey INTEGER, shape ST_Geometry);
INSERT sample_shapes
(1,'Polygon((30 30, 30 60, 60 60, 60 30, 30 30))');
SELECT skey
FROM sample_shapes
WHERE (shape.ST_Area() < 100.5);