5. Geospatial Functions : Perimeter
 
Share this page                  
Perimeter
PERIMETER(g Geometry)
Alias: ST_PERIMETER
Returns the length of the perimeter of g.
Result type: float
Example:
SELECT PERIMETER(POLYFROMTEXT('POLYGON((0 0, 0 20, 15 20, 15 16, 10 16, 10 14, 15 14, 15 0, 0 0))'));
-----------
col1
-----------
80.000
-----------