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.