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

ST_MPolyFromText

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


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