ST_IsClosed() method

Tests if the ST_MultiCurve value is closed. A curve is closed if the start and end points are coincident. A multicurve is closed if it is non-empty and has an empty boundary.

Syntax

multicurve-expression.ST_IsClosed()

Returns

BIT Returns 1 if the multicurve is closed, otherwise 0.

Examples

Example 1 – The following returns the result 0 because the boundary of the multicurve has two points.
```
SELECT NEW ST_MultiCurve( 'MultiCurve((0 0, 1 1))' ).ST_IsClosed()
```
The following returns all rows in multicurve_table that have closed geometries. This example assumes the geometry column has type ST_MultiCurve or ST_MultiLineString.
```
SELECT * FROM multicurve_table WHERE geometry.ST_IsClosed() = 1
```

Standards

SQL/MM (ISO/IEC 13249-3: 2006) 9.3.3