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