ST_PointNÀº ¼±½ºÆ®¸µ°ú Á¤¼ö »öÀÎÀ» ÃëÇØ ¼±½ºÆ®¸µÀÇ °æ·Î¿¡ ÀÖ´Â N¹øÂ° Á¤Á¡ÀÎ Á¡À» ¸®ÅÏÇÕ´Ï´Ù.
±¸¹®
db2gse.ST_PointN(l db2gse.ST_Curve, n Integer)
¸®ÅÏ À¯Çü
db2gse.ST_Point
¿¹
´ÙÀ½ÀÇ CREATE TABLE¹®Àº °¢ ÇàÀ» °íÀ¯ÇÏ°Ô ³ªÅ¸³»´Â GID Ä÷³°ú LN1 ¼±½ºÆ®¸µ Ä÷³ µÎ °³°¡ ÀÖ´Â POINTN_TEST Å×À̺íÀ» ÀÛ¼ºÇÕ´Ï´Ù.
CREATE TABLE POINTN_TEST (gid integer, ln1 db2gse.ST_LineString)
´ÙÀ½ÀÇ INSERT¹®Àº µÎ ¼±½ºÆ®¸µ°ªÀ» »ðÀÔÇÕ´Ï´Ù. ù¹øÂ° ¼±½ºÆ®¸µ¿¡´Â Z ÁÂÇ¥³ª Ä¡¼ö°¡ µé¾î ÀÖÁö ¾ÊÀ¸¸ç µÎ ¹øÂ° ¼±½ºÆ®¸µ¿¡´Â µÑ ¸ðµÎ µé¾î ÀÖ½À´Ï´Ù.
INSERT INTO POINTN_TEST VALUES(1, db2gse.ST_LineFromText('linestring (10.02 20.01,23.73 21.92,30.10 40.23)', db2gse.coordref()..srid(0))) INSERT INTO POINTN_TEST VALUES(2, db2gse.ST_LineFromText('linestring zm (10.02 20.01 5.0 7.0,23.73 21.92 6.5 7.1, 30.10 40.23 6.9 7.2)', db2gse.coordref()..srid(0)))
´ÙÀ½ÀÇ SELECT¹® ¹× ÇØ´ç °á°ú ¼¼Æ®¿¡¼´Â GID Ä÷³°ú °¢ ¼±½ºÆ®¸µÀÇ µÎ ¹øÂ° Á¤Á¡À» ³ª¿ÇÕ´Ï´Ù. ù¹øÂ° ÇàÀÇ °á°ú´Â Z ÁÂÇ¥ ¶Ç´Â Ä¡¼ö°¡ ¾ø´Â Á¡ÀÌ°í µÎ ¹øÂ° Çà °á°ú´Â Z ÁÂÇ¥ ¶Ç´Â Ä¡¼ö°¡ ÀÖ´Â Á¡ÀÔ´Ï´Ù. ST_PointN ÇÔ¼ö´Â Á¡ÀÌ ¼Ò½º ¼±½ºÆ®¸µ¿¡ Á¸ÀçÇÏ´Â °æ¿ì¿¡´Â Z ÁÂÇ¥ ¶Ç´Â Â÷¿ø°ú ÇÔ²² Á¡À» ¸®ÅÏÇÕ´Ï´Ù.
SELECT gid, CAST(db2gse.ST_AsText(db2gse.ST_PointN(ln1,2)) AS varchar(60)) "The 2nd vertice" FROM POINTN_TEST GID The 2nd vertice ----------- ------------------------------------------------------------ 1 POINT ( 23.73000000 21.92000000) 2 POINT ZM ( 23.73000000 21.92000000 7.00000000 7.10000000) 2 record(s) selected.