The area
function returns the area of a
spherical object in square radians. Supported data types are:
scircle
, spolygon
, sbox
,
smoc
. The polygon should be convex, otherwise the
behaviour is undefined.
Example 6.1. Area of a spherical circle as a multiple of π
sql> SELECT area( scircle '<(0d,90d),60d>' ) / pi() AS area; area ------ 1 (1 row)
Example 6.2. Area of a Multi-Order Coverage (MOC) object
sql> SELECT area(smoc '0/1-3'); area ------------------- 3.141592653589793 (1 row)