ST_MPolyFromText´Â ´ÙÁßÁ¡ À¯ÇüÀÇ Àß ¾Ë·ÁÁø ÅØ½ºÆ® Ç¥Çö½Ä ¹× °ø°£ ÂüÁ¶ ½Ã½ºÅÛ ½Äº°ÀÚ¸¦ ÃëÇØ ´ÙÁß ´Ù°¢ÇüÀ» ¸®ÅÏÇÕ´Ï´Ù.
ÀÌ ÇÔ¼ö´Â °°Àº ÁÂÇ¥¸¦ °¡Áø ´ÙÁß ´Ù°¢ÇüÀÌ Æ÷ÇÔµÈ ´ÙÁß ´Ù°¢ÇüÀ» ÀÔ·ÂÀ¸·Î ÃëÇÒ ¼ö ¾ø½À´Ï´Ù.
±¸¹®
db2gse.ST_MPolyFromText(multiPolygonTaggedText Varchar(4000), SRID db2gse.coordref)
¸®ÅÏ À¯Çü
db2gse.ST_MultiPolygon
¿¹
´ÙÀ½ÀÇ CREATE TABLE¹®Àº ÇϳªÀÇ MPL1 ´ÙÁß ´Ù°¢Çü Ä÷³ÀÌ ÀÖ´Â MULTIPOLYGON_TEST Å×À̺íÀ» ÀÛ¼ºÇÕ´Ï´Ù.
CREATE TABLE MULTIPOLYGON_TEST (mpl1 db2gse.ST_MultiPolygon)
´ÙÀ½ÀÇ INSERT¹®Àº ST_MPolyFromText ÇÔ¼ö¸¦ »ç¿ëÇÏ¿© MPL1 Ä÷³¿¡ ´ÙÁß´Ù°¢ÇüÀ» »ðÀÔÇÕ´Ï´Ù.
INSERT INTO MULTIPOLYGON_TEST VALUES ( db2gse.ST_MPolyFromText('multipolygon(((10.01 20.03,10.52 40.11, 30.29 41.56,31.78 10.74,10.01 20.03),(21.23 15.74,21.34 35.21,28.94 35.35, 29.02 16.83, 21.23 15.74)),((40.91 10.92,40.56 20.19, 50.01 21.12,51.34 9.81, 40.91 10.92)))', db2gse.coordref()..srid(0)))