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

ST_MLineFromText

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

±¸¹®

db2gse.ST_MLineFromText(multiLineStringTaggedText String, SRID db2gse.coordref)

¸®ÅÏ À¯Çü

db2gse.ST_MultiLineString

¿¹

´ÙÀ½ÀÇ CREATE TABLE¹®Àº MLINESTRING_TEST Å×À̺íÀ» ÀÛ¼ºÇÕ´Ï´Ù. MLINESTRING_TEST¿¡´Â ÇàÀ» °íÀ¯ÇÏ°Ô ³ªÅ¸³»´Â GID smallint Ä÷³°ú ML1 ´ÙÁß ¼±½ºÆ®¸µ Ä÷³ÀÌ ÀÖ½À´Ï´Ù.

CREATE TABLE ST_MLINESTRING_TEST (gid smallint, ml1 db2gse.ST_MultiLineString) 

´ÙÀ½ÀÇ INSERT¹®Àº ST_MLineFromText ÇÔ¼ö·Î ´ÙÁß ¼±½ºÆ®¸µÀ» »ðÀÔÇÕ´Ï´Ù.

INSERT INTO MLINESTRING_TEST
VALUES (1, db2gse.ST_MLineFromText('multilinestring((10.01 20.03,10.52 40.11,
         30.29 41.56,31.78 10.74),
                                         (20.93 20.81, 21.52 40.10))',
                         db2gse.coordref()..srid(0)))


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