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

ST_IsRing

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.


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