ST_IsRingÀº ¼±½ºÆ®¸µÀ» ÃëÇØ ±×°ÍÀÌ ¸µÀ̸é Áï, ¼±½ºÆ®¸µÀÌ ´ÝÈù »óÅÂÀÌ°í ´Ü¼øÇϸé 1(TRUE)À» ¸®ÅÏÇϰí, ±×·¸Áö ¾ÊÀ¸¸é 0(FALSE)À» ¸®ÅÏÇÕ´Ï´Ù.
±¸¹®
db2gse.ST_IsRing(c db2gse.ST_Curve)
¸®ÅÏ À¯Çü
Integer
¿¹
´ÙÀ½ÀÇ CREATE TABLE ¸í·É¹®Àº LN1À̶ó´Â ´ÜÀÏ ¼±½ºÆ®¸µ Ä÷³ÀÌ ÀÖ´Â RING_LINESTRING Å×À̺íÀ» ÀÛ¼ºÇÕ´Ï´Ù.
CREATE TABLE RING_LINESTRING (ln1 db2gse.ST_LineString)
´ÙÀ½ÀÇ INSERT¹®Àº LN1 Ä÷³¿¡ ¼¼ °³ÀÇ ¼±½ºÆ®¸µÀ» »ðÀÔÇÕ´Ï´Ù. ù¹øÂ° Çà¿¡´Â ´ÝÇô ÀÖÁö ¾Ê´Â ¼±½ºÆ®¸µÀÌ µé¾î ÀÖÀ¸¹Ç·Î ¼±½ºÆ®¸µÀÌ ¸µÀÌ ¾Æ´Õ´Ï´Ù. µÎ ¹øÂ° Çà¿¡´Â ´ÝÈù »óÅÂÀÇ ´Ü¼øÇÑ ¼±½ºÆ®¸µÀÌ µé¾î ÀÖÀ¸¹Ç·Î ¸µÀÔ´Ï´Ù. ¼¼ ¹øÂ° Çà¿¡´Â ´ÝÈù »óÅÂÀÌÁö¸¸ ±× ÀÚ½ÅÀÇ ³»ºÎ¿Í ±³Â÷Çϱ⠶§¹®¿¡ ´Ü¼øÇÏÁö ¾ÊÀº ¼±½ºÆ®¸µÀÌ µé¾î ÀÖÀ¸¹Ç·Î ¸µÀÌ ¾Æ´Õ´Ï´Ù.
INSERT INTO RING_LINESTRING VALUES(db2gse.ST_LineFromText('linestring (10.02 20.01,10.32 23.98, 11.92 25.64)', db2gse.coordref()..srid(0))) INSERT INTO RING_LINESTRING VALUES(db2gse.ST_LineFromText('linestring (10.02 20.01,11.92 35.64,25.02 34.15, 19.15 33.94, 10.02 20.01)', db2gse.coordref()..srid(0))) INSERT INTO RING_LINESTRING VALUES(db2gse.ST_LineFromText('linestring (15.47 30.12,20.73 22.12,10.83 14.13, 16.45 17.24,21.56 13.37,11.23 22.56, 19.11 26.78,15.47 30.12)', db2gse.coordref()..srid(0)))
´ÙÀ½ÀÇ SELECT¹® ¹× ÇØ´ç °á°ú ¼¼Æ®¿¡¼´Â ST_IsRing ÇÔ¼öÀÇ °á°ú¸¦ º¸¿©ÁÝ´Ï´Ù. ù¹øÂ° ¹× ¼¼ ¹øÂ° ÇàÀº 0À» ¸®ÅÏÇÕ´Ï´Ù. ÀÌ´Â ¼±½ºÆ®¸µÀÌ ¸µÀÌ ¾Æ´Ï±â ¶§¹®ÀÌÁö¸¸, µÎ ¹øÂ° ÇàÀº ¼±½ºÆ®¸µÀÌ ¸µÀ̱⠶§¹®¿¡ 1À» ¸®ÅÏÇÕ´Ï´Ù.
SELECT db2gse.ST_IsRing(ln1) "Is it ring" FROM RING_LINESTRING Is it ring ----------- 0 1 0 3 record(s) selected.