ST_PolygonÀº ST_LineStringÀ¸·ÎºÎÅÍ ST_PolygonÀ» »ý¼ºÇÕ´Ï´Ù.
±¸¹®
db2gse.ST_Polygon(l db2gse.ST_LineString)
¸®ÅÏ À¯Çü
db2gse.ST_Polygon
¿¹
´ÙÀ½ÀÇ CREATE TABLE¹®Àº ÇϳªÀÇ P1 Ä÷³ÀÌ ÀÖ´Â POLYGON_TEST Å×À̺íÀ» ÀÛ¼ºÇÕ´Ï´Ù.
CREATE TABLE POLYGON_TEST (p1 db2gse.ST_polygon)
´ÙÀ½ÀÇ INSERT¹®Àº ¸µ(´ÝÇô ÀÖ´Â ¼±½ºÆ®¸µ ¹× ´Ü¼øÇÑ ¼±½ºÆ®¸µ ¸ðµÎ)À» ´Ù°¢ÇüÀ¸·Î º¯È¯Çϰí, ST_Polygon ÇÔ¼ö ³»ÀÇ ST_LineFromText ÇÔ¼ö¸¦ »ç¿ëÇÏ¿© P1 Ä÷³À¸·Î À̸¦ »ðÀÔÇÕ´Ï´Ù.
INSERT INTO POLYGON_TEST VALUES ( db2gse.ST_Polygon(db2gse.ST_LineFromText('linestring(10.01 20.03,20.94 21.34,35.93 10.04,10.01 20.03)', db2gse.coordref()..srid(0))) )