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

ST_LineFromText

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

±¸¹®

db2gse.ST_LineFromText(lineStringTaggedText Varchar(4000), SRID db2gse.coordref)

¸®ÅÏ À¯Çü

db2gse.ST_LineString

¿¹

´ÙÀ½ÀÇ CREATE TABLE¹®Àº ÇϳªÀÇ LN1 ¼±½ºÆ®¸µ Ä÷³ÀÌ ÀÖ´Â LINESTRING_TEST Å×À̺íÀ» ÀÛ¼ºÇÕ´Ï´Ù.

CREATE TABLE LINESTRING_TEST (ln1 db2gse.ST_LineString)

´ÙÀ½ÀÇ INSERT¹®Àº ST_LineFromText ÇÔ¼ö¸¦ »ç¿ëÇÏ¿© LN1 Ä÷³¿¡ ¼±½ºÆ®¸µÀ» »ðÀÔÇÕ´Ï´Ù.

INSERT INTO LINESTRING_TEST
VALUES (db2gse.ST_LineFromText('linestring(10.01 20.03,20.94 21.34,
        35.93 19.04)', db2gse.coordref()..srid(0)))


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