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.