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

ST_IsClosed

ST_IsClosed´Â ¼±½ºÆ®¸µ ¶Ç´Â ´ÙÁß ¼±½ºÆ®¸µÀ» ÃëÇØ ±×°ÍÀÌ ´ÝÇô ÀÖÀ¸¸é 1(TRUE)À» ¸®ÅÏÇÏ°í ±×·¸Áö ¾ÊÀ¸¸é 0(FALSE)À» ¸®ÅÏÇÕ´Ï´Ù.

±¸¹®
db2gse.ST_IsClosed(c db2gse.ST_Curve)
db2gse.ST_IsClosed(mc db2gse.ST_MultiCurve)

¸®ÅÏ À¯Çü

Integer

¿¹

´ÙÀ½ÀÇ CREATE TABLE ¹®Àº ÇϳªÀÇ ¼±½ºÆ®¸µ Ä÷³ÀÌ ÀÖ´Â CLOSED_LINESTRING Å×À̺íÀ» ÀÛ¼ºÇÕ´Ï´Ù.

CREATE TABLE CLOSED_LINESTRING (ln1 db2gse.ST_LineString) 

´ÙÀ½ÀÇ INSERT¹®Àº CLOSED_LINESTRING Å×ÀÌºí¿¡ µÎ °³ÀÇ ·¹Äڵ带 »ðÀÔÇÕ´Ï´Ù. ù¹øÂ° ·¹ÄÚµå´Â ´ÝÈù ¼±½ºÆ®¸µÀÌ ¾Æ´Ï°í µÎ ¹øÂ°´Â ´ÝÈù ¼±½ºÆ®¸µÀÔ´Ï´Ù.

INSERT INTO CLOSED_LINESTRING
VALUES(db2gse.ST_LineFromText('linestring  (10.02 20.01,10.32 23.98,
       11.92 25.64)', db2gse.coordref()..srid(0)))
 
INSERT INTO CLOSED_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))) 

´ÙÀ½ÀÇ SELECT¹®°ú ÇØ´ç °á°ú ¼¼Æ®¿¡¼­´Â ST_IsClosed ÇÔ¼öÀÇ °á°ú¸¦ º¸¿©ÁÝ´Ï´Ù. ù¹øÂ° ÇàÀº ¼±½ºÆ®¸µÀÌ ´ÝÈ÷Áö ¾Ê¾Ò±â ¶§¹®¿¡ 0À» ¸®ÅÏÇÏ´Â ¹Ý¸é, µÎ ¹øÂ° ÇàÀº ¼±½ºÆ®¸µÀÌ ´ÝÇô ÀÖÀ¸¹Ç·Î 1À» ¸®ÅÏÇÕ´Ï´Ù.

SELECT db2gse.ST_IsClosed(ln1) "Is it closed" FROM CLOSED_LINESTRING
 
Is it closed
------------
0 
1 
 
  2 record(s) selected.

´ÙÀ½ÀÇ CREATE TABLE¹®Àº ÇϳªÀÇ ´ÙÁß ¼±½ºÆ®¸µ Ä÷³ÀÌ ÀÖ´Â CLOSED_MULTILINESTRING Å×À̺íÀ» ÀÛ¼ºÇÕ´Ï´Ù.

CREATE TABLE CLOSED_MULTILINESTRING (mln1 db2gse.ST_MultiLineString) 

´ÙÀ½ÀÇ INSERT¹®Àº CLOSED_MULTILINESTRING¿¡ µÎ °³ÀÇ ·¹ÄÚµå Áï, ´ÝÈ÷Áö ¾ÊÀº ´ÙÁß ¼±½ºÆ®¸µ ·¹ÄÚµå¿Í ´ÝÈù ¶Ç´Ù¸¥ ´ÙÁß ¼±½ºÆ®¸µ ·¹Äڵ带 »ðÀÔÇÕ´Ï´Ù.

INSERT INTO CLOSED_MULTILINESTRING
VALUES(db2gse.ST_MLineFromText('multilinestring ((10.02 20.01,10.32 23.98,
       11.92 25.64), (9.55 23.75,15.36 30.11))',
                     db2gse.coordref()..srid(0)))
 
INSERT INTO CLOSED_MULTILINESTRING
VALUES(db2gse.ST_MLineFromText('multilinestring ((10.02 20.01,11.92 35.64,
       25.02 34.15, 19.15 33.94,10.02 20.01),
                                       (51.71 21.73,73.36 27.04,71.52 32.87,
                                        52.43 31.90,51.71 21.73))',
                     db2gse.coordref()..srid(0))) 

´ÙÀ½ÀÇ SELECT¹®°ú ÇØ´ç °á°ú ¼¼Æ®¿¡¼­´Â ST_IsClosed ÇÔ¼öÀÇ °á°ú¸¦ º¸¿©ÁÝ´Ï´Ù. ù¹øÂ° ÇàÀº ´ÙÁß ¼±½ºÆ®¸µÀÌ ´ÝÇô ÀÖÁö ¾Ê¾Æ 0À» ¸®ÅÏÇÏÁö¸¸ µÎ ¹øÂ° ÇàÀº ´ÙÁß ¼±½ºÆ®¸µÀÌ ´ÝÈù »óÅÂÀ̹ǷΠ1À» ¸®ÅÏÇÕ´Ï´Ù. ´ÙÁß ¼±½ºÆ®¸µÀÇ ¼±½ºÆ®¸µ ¿ä¼Ò ¸ðµÎ°¡ ´ÝÈù »óÅÂÀÌ¸é ´ÙÁß ¼±½ºÆ®¸µÀº ´ÝÈü´Ï´Ù.

SELECT db2gse.ST_IsClosed(mln1) "Is it closed" FROM CLOSED_MULTILINESTRING
 
Is it closed
------------
0 
1 
 
  2 record(s) selected.


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