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

ST_PointFromText

ST_PointFromText´Â Á¡ À¯ÇüÀÇ Àß ¾Ë·ÁÁø ÅØ½ºÆ® Ç¥Çö½Ä ¹× °ø°£ ÂüÁ¶ ½Ã½ºÅÛ ½Äº°ÀÚ¸¦ ÃëÇØ Á¡À» ¸®ÅÏÇÕ´Ï´Ù.

±¸¹®

db2gse.ST_PointFromText(pointTaggedText Varchar(4000), SRID db2gse.coordref)

¸®ÅÏ À¯Çü

db2gse.ST_Point

¿¹

´ÙÀ½ÀÇ CREATE TABLE¹®Àº ÇϳªÀÇ PT1 Á¡ Ä÷³ÀÌ ÀÖ´Â POINT_TEST Å×À̺íÀ» ÀÛ¼ºÇÕ´Ï´Ù.

CREATE TABLE POINT_TEST (pt1 db2gse.ST_Point)

INSERT¹®ÀÌ PT1 Ä÷³¿¡ Á¡À» »ðÀÔÇϱâ Àü¿¡ ST_PointFromText ÇÔ¼ö´Â Á¡ ÅØ½ºÆ® ÁÂÇ¥¸¦ Á¡ Çü½ÄÀ¸·Î º¯È¯ÇÕ´Ï´Ù.

INSERT INTO POINT_TEST VALUES (
       db2gse.ST_PointFromText ('point(10.01 20.03)', 
         db2gse.coordref()..srid(0))) 


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