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

IsMeasured

IsMeasured´Â ±âÇÏ ¿ÀºêÁ§Æ®¸¦ ÃëÇØ ¿ÀºêÁ§Æ®¿¡ ÃøÁ¤ÀÌ ÀÖ´Â °æ¿ì 1(TRUE)À» ¸®ÅÏÇϰí, ±×·¸Áö ¾ÊÀº °æ¿ì 0(FALSE)À» ¸®ÅÏÇÕ´Ï´Ù.

±¸¹®

db2gse.IsMeasured(g db2gse.ST_Geometry)

¸®ÅÏ À¯Çü

Integer

¿¹

´ÙÀ½ CREATE TABLE ¸í·É¹®Àº Ä÷³ÀÌ µÎ °³ÀÎ MEASURE_TEST Å×À̺íÀ» ÀÛ¼ºÇÕ´Ï´Ù.

CREATE TABLE MEASURE_TEST (gid smallint, g1 db2gse.ST_Geometry)

´ÙÀ½ INSERT¹®Àº µÎ ·¹Äڵ带 MEASURE_TEST Å×ÀÌºí¿¡ »ðÀÔÇÕ´Ï´Ù. ù¹øÂ° ·¹ÄÚµå´Â Ä¡¼ö°¡ ¾ø´Â Á¡À» ÀúÀåÇÕ´Ï´Ù. µÎ ¹øÂ° ·¹ÄÚµåÀÇ Á¡¿¡´Â Ä¡¼ö°¡ ÀÖ½À´Ï´Ù.

INSERT INTO MEASURE_TEST
VALUES(1, db2gse.ST_PointFromText('point (10 10)', db2gse.coordref()..srid(0)))
 
INSERT INTO MEASURE_TEST
VALUES (2, db2gse.ST_PointFromText('point m (10.92 10.12 5)', 
    db2gse.coordref()..srid(0)))

´ÙÀ½ÀÇ SELECT¹®°ú ÇØ´ç °á°ú ¼¼Æ®¿¡¼­´Â IsMeasured ÇÔ¼öÀÇ °á°ú¿Í ÇÔ²² GID Ä÷³ÀÇ ³»¿ëÀ» º¸¿© ÁÝ´Ï´Ù. ù¹øÂ° Çà¿¡´Â Á¡¿¡ Ä¡¼ö°¡ ¾øÀ¸¹Ç·Î IsMeasured ÇÔ¼ö°¡ 0À» ¸®ÅÏÇÕ´Ï´Ù. µÎ ¹øÂ° Çà¿¡´Â Á¡¿¡ Ä¡¼ö°¡ ÀÖÀ¸¹Ç·Î 1À» ¸®ÅÏÇÕ´Ï´Ù.

SELECT gid, db2gse.IsMeasured (g1) "Has measures?" FROM MEASURE_TEST
gid      Has measures
------   ----------
     1            0
     2            1


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