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)))