当输入Geometry对象在判定条件ST_IsClosed下为true且ST_IsSimple也为true时，返回true。

语法

boolean  ST_IsRing(geometry  g);

参数

参数名称 描述
g 目标Geometry对象。

示例

  • 返回true的情况：
    SELECT ST_IsRing(geom), ST_IsClosed(geom), ST_IsSimple(geom) FROM (SELECT 'LINESTRING(0 0,0 2,2 0,0 0)'::geometry AS geom) AS test;
 st_isring | st_isclosed | st_issimple
-----------+-------------+-------------
 t         | t           | t
(1 row)
  • 返回false的情况：
    SELECT ST_IsRing(geom), ST_IsClosed(geom), ST_IsSimple(geom) FROM (SELECT 'LINESTRING(0 0,0 2,0 0)'::geometry AS geom) AS test;
 st_isring | st_isclosed | st_issimple
-----------+-------------+-------------
 f         | t           | f
(1 row)