ST_IsSimpleÀº ±âÇÏÇÐ ¿ÀºêÁ§Æ®¸¦ ÃëÇØ ¿ÀºêÁ§Æ®°¡ °£´ÜÇϸé 1(TRUE)À» ¸®ÅÏÇÏ°í ±×·¸Áö ¾ÊÀ¸¸é 9(FALSE)¸¦ ¸®ÅÏÇÕ´Ï´Ù.
±¸¹®
db2gse.ST_IsSimple(g db2gse.ST_Geometry)
¸®ÅÏ À¯Çü
Integer
¿¹
´ÙÀ½ CREATE TABLE ¸í·É¹®Àº Ä÷³ÀÌ µÎ °³ÀÎ ISSIMPLE_TEST Å×À̺íÀ» ÀÛ¼ºÇÕ´Ï´Ù. smallintÀÎ PID Ä÷³¿¡´Â °¢ Çà¿¡ ´ëÇÑ °íÀ¯ ½Äº°ÀÚ°¡ µé¾î ÀÖ½À´Ï´Ù. G1 ±âÇÏÇÐ Ä÷³Àº ´Ü¼øÇÑ ±âÇÏÇÐ »ùÇðú ´Ü¼øÇÏÁö ¾ÊÀº ±âÇÏÇÐ Ä÷³À» ÀúÀåÇÕ´Ï´Ù.
CREATE TABLE ISSIMPLE_TEST (pid smallint, g1 db2gse.ST_Geometry)
´ÙÀ½ INSERT¹®Àº µÎ ·¹Äڵ带 ISSIMPLE_TEST Å×ÀÌºí¿¡ »ðÀÔÇÕ´Ï´Ù. ù¹øÂ°´Â ³»ºÎ¿Í ±³Â÷ÇÏÁö ¾Ê´Â ¼±½ºÆ®¸µÀ̹ǷΠ´Ü¼øÇÕ´Ï´Ù. µÎ ¹øÂ°´Â ³»ºÎ¿Í ±³Â÷ÇϹǷΠ´Ü¼øÇÏÁö ¾Ê½À´Ï´Ù.
INSERT INTO ISSIMPLE_TEST VALUES (1, db2gse.ST_LineFromText('linestring (10 10, 20 20, 30 30)', db2gse.coordref()..srid(0))) INSERT INTO ISSIMPLE_TEST VALUES (2, db2gse.ST_LineFromText('linestring (10 10, 20 20,20 30,10 30,10 20, 20 10)', db2gse.coordref()..srid(0)))
´ÙÀ½ÀÇ SELECT¹® ¹× ÇØ´ç °á°ú ¼¼Æ®¿¡¼´Â ST_IsSimple ÇÔ¼öÀÇ °á°ú¸¦ º¸¿©ÁÝ´Ï´Ù. ù¹øÂ° ·¹ÄÚµå´Â ¼±½ºÆ®¸µÀÌ ´Ü¼øÇϹǷΠ1À» ¸®ÅÏÇϸç, µÎ ¹øÂ° ·¹ÄÚµå´Â ¼±½ºÆ®¸µÀÌ ´Ü¼øÇÏÁö ¾ÊÀ¸¹Ç·Î 0À» ¸®ÅÏÇÕ´Ï´Ù.
SELECT ST_IsSimple(g1) FROM ISSIMPLE_TEST g1 -------------- 1 0