Available in versions: Dev (3.20)
This documentation is for the unreleased development version of jOOQ. Click on the above version links to get this documentation for a supported version of jOOQ.
ST_IsRing
Applies to ❌ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition
create.select(
stIsRing(stGeomFromText("LINESTRING (0 0, 1 1, 2 0, 0 0)"))
stIsRing(stGeomFromText("LINESTRING (0 0, 1 1, 2 0)")),
).fetch();
The result being, for example
+-----------+-----------+ | ST_IsRing | ST_IsRing | +-----------+-----------+ | true | false | +-----------+-----------+
Or, visually:
Dialect support
This example using jOOQ:
stIsRing(geometry)
Translates to the following dialect specific expressions:
Aurora MySQL, Aurora Postgres, CockroachDB, DuckDB, MariaDB, Postgres, Redshift
st_isring(geometry)
MySQL
( st_isclosed(geometry) AND st_issimple(geometry) )
Oracle
( (sdo_relate(sdo_lrs.geom_segment_start_pt(geometry), sdo_lrs.geom_segment_end_pt(geometry), 'mask=EQUAL')) AND (st_geometry(geometry).st_issimple()) )
ASE, Access, BigQuery, ClickHouse, DB2, Derby, Exasol, Firebird, H2, HSQLDB, Hana, Informix, MemSQL, SQLDataWarehouse, SQLServer, SQLite, Snowflake, Sybase, Teradata, Trino, Vertica, YugabyteDB
/* UNSUPPORTED */
Generated with jOOQ 3.20. Translate your own SQL on our website
Feedback
Do you have any feedback about this page? We'd love to hear it!