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

ST_MPointFromText

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

±¸¹®

db2gse.ST_MPointFromText(multiPointTaggedText Varchar(4000), SRID db2gse.coordref)

¸®ÅÏ À¯Çü

db2gse.ST_MultiPoint

¿¹

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

CREATE TABLE MULTIPOINT_TEST (mpt1 db2gse.ST_MultiPoint) 

´ÙÀ½ÀÇ INSERT¹®Àº ST_MPointFromText Ä÷³À» »ç¿ëÇÏ¿© MPT1 Ä÷³¿¡ ´ÙÁßÁ¡À» »ðÀÔÇÕ´Ï´Ù.

INSERT INTO MULTIPOINT_TEST
VALUES (1, db2gse.ST_MPointFromText('multipoint(10.01 20.03,10.52 40.11,
                                    30.29 41.56,31.78 10.74)',
                         db2gse.coordref()..srid(0)))


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