»ç¿ëÀÚ ¾È³» ¹× ÂüÁ¶¼­

ST_IsSimple

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 


[ ÆäÀÌÁöÀÇ ¸Ç À§ | ÀÌÀü ÆäÀÌÁö | ´ÙÀ½ ÆäÀÌÁö | ¸ñÂ÷ | »öÀÎ ]