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

ST_PolyFromText

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

±¸¹®

db2gse.ST_PolyFromText(polygonTaggedText Varchar(4000), SRID db2gse.coordref)

¸®ÅÏ À¯Çü

db2gse.ST_Polygon

¿¹

´ÙÀ½ÀÇ CREATE TABLE¹®Àº ÇϳªÀÇ ´Ù°¢Çü Ä÷³ÀÌ ÀÖ´Â POLYGON_TEST Å×À̺íÀ» ÀÛ¼ºÇÕ´Ï´Ù.

CREATE TABLE POLYGON_TEST (pl1 db2gse.ST_Polygon) 

´ÙÀ½ÀÇ INSERT¹®Àº ST_PolyFromText ÇÔ¼ö¸¦ »ç¿ëÇÏ¿© ´Ù°¢Çü Ä÷³¿¡ ´Ù°¢ÇüÀ» »ðÀÔÇÕ´Ï´Ù.

INSERT INTO POLYGON_TEST VALUES (db2gse.ST_PolyFromText(
'polygon((10.01 20.03,10.52 40.11,30.29 
41.56, 31.78 10.74,10.01 20.03))', 
    db2gse.coordref()..srid(0))) 


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