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

ST_Polygon

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


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