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

ST_PointN

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. 


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