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

ST_Endpoint

ST_Endpoint´Â ¼±½ºÆ®¸µÀ» ÃëÇØ ¼±½ºÆ®¸µÀÇ ÃÖÁ¾ ÁöÁ¡ÀÎ Á¡ Çϳª¸¦ ¸®ÅÏÇÕ´Ï´Ù.

±¸¹®

db2gse.ST_Endpoint(c db2gse.ST_Curve)

¸®ÅÏ À¯Çü

db2gse.ST_Point

¿¹

ENDPOINT_TEST Å×À̺íÀº ¼±½ºÆ®¸µÀ» ÀúÀåÇÏ´Â °¢ Çà°ú LN1 ¼±½ºÆ®¸µ Ä÷³À» °íÀ¯ÇÏ°Ô ³ªÅ¸³»´Â GID Á¤¼ö Ä÷³À» ÀúÀåÇÕ´Ï´Ù.

CREATE TABLE ENDPOINT_TEST (gid integer, ln1 db2gse.ST_LineString)

INSERT¹®Àº ENDPOINT_TEST Å×ÀÌºí¿¡ ¼±½ºÆ®¸µÀ» »ðÀÔÇÕ´Ï´Ù. ù¹øÂ° ¸í·É¹®¿¡´Â Z ÁÂÇ¥³ª Ä¡¼ö°¡ µé¾î ÀÖÁö ¾ÊÀ¸¸ç µÎ ¹øÂ°¿¡´Â µé¾î ÀÖ½À´Ï´Ù.

INSERT INTO ENDPOINT_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 ENDPOINT_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¹®Àº ST_Endpoint ÇÔ¼öÀÇ °á°ú¿Í ÇÔ²² GID Ä÷³À» ³ª¿­ÇÕ´Ï´Ù. ST_Endpoint ÇÔ¼ö´Â ST_AsText ÇÔ¼ö¿¡ ÀÇÇØ ÅØ½ºÆ®·Î º¯È¯µÈ Á¡ ±âÇÏÇÐÀ» »ý¼ºÇÕ´Ï´Ù. CAST ÇÔ¼ö´Â ST_AsText ÇÔ¼öÀÇ ±âº» varchar(4000) °ªÀ» varchar(60)À¸·Î ´ÜÃàÇÏ´Â µ¥ »ç¿ëµË´Ï´Ù.

SELECT gid, CAST(db2gse.ST_AsText(db2gse.ST_Endpoint(ln1)) AS varchar(60)) 
"Endpoint"
FROM ENDPOINT_TEST

´ÙÀ½ÀÇ °á°ú ¼¼Æ®°¡ ¸®Åϵ˴ϴÙ.

GID         Endpoint
----------- ------------------------------------------------------------
          1 POINT ( 30.10000000 40.23000000)
          2 POINT ZM ( 30.10000000 40.23000000 7.00000000 7.20000000)
 
  2 record(s) selected.


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