ST_StartPoint´Â ¼±½ºÆ®¸µÀ» ÃëÇØ ¼±½ºÆ®¸µÀÇ Ã¹¹øÂ° Á¡ÀÎ Á¡ Çϳª¸¦ ¸®ÅÏÇÕ´Ï´Ù.
±¸¹®
db2gse.ST_StartPoint(c db2gse.ST_Curve)
¸®ÅÏ À¯Çü
db2gse.ST_Point
¿¹
´ÙÀ½ÀÇ CREATE TABLE¹®Àº STARTPOINT_TEST Å×À̺íÀ» ÀÛ¼ºÇÕ´Ï´Ù. STARTPOINT_TEST¿¡´Â Å×À̺í ÇàÀ» °íÀ¯ÇÏ°Ô ³ªÅ¸³»´Â GID Á¤¼ö Ä÷³°ú LN1 ¼±½ºÆ®¸µ Ä÷³ µÎ °³°¡ ÀÖ½À´Ï´Ù.
CREATE TABLE STARTPOINT_TEST (gid integer, ln1 db2gse.ST_LineString)
´ÙÀ½ÀÇ INSERT¹®Àº LN1 Ä÷³À¸·Î ¼±½ºÆ®¸µÀ» »ðÀÔÇÕ´Ï´Ù. ù¹øÂ° ¼±½ºÆ®¸µ¿¡´Â Z ÁÂÇ¥³ª Ä¡¼ö°¡ µé¾î ÀÖÁö ¾ÊÀ¸¸ç µÎ ¹øÂ° ¼±½ºÆ®¸µ¿¡´Â µÑ ¸ðµÎ µé¾î ÀÖ½À´Ï´Ù.
INSERT INTO STARTPOINT_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 STARTPOINT_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_StartPoint ÇÔ¼ö°¡ °¢ ¼±½ºÆ®¸µÀÇ Ã¹¹øÂ° Á¡À» ¹ßÃéÇÏ´Â ¹æ¹ýÀ» º¸¿© ÁÝ´Ï´Ù. ST_AsText ÇÔ¼ö´Â Á¡À» ÀÌÀÇ ÅØ½ºÆ® Çü½ÄÀ¸·Î º¯È¯ÇÕ´Ï´Ù. ¸ñ·ÏÀÇ Ã¹¹øÂ° Á¡¿¡´Â Z ÁÂÇ¥ ¶Ç´Â Ä¡¼ö°¡ ¾ø´Â ¹Ý¸é¿¡, µÎ ¹øÂ° Á¡¿¡´Â ¼Ò½º ¼±½ºÆ®¸µ¿¡ Z ÁÂÇ¥ ¶Ç´Â Ä¡¼ö°¡ Àֱ⠶§¹®¿¡ µÑ ¸ðµÎ ÀÖ½À´Ï´Ù.
SELECT gid, CAST(db2gse.ST_AsText(db2gse.ST_StartPoint (ln1)) as varchar(60)) "Startpoint" FROM STARTPOINT_TEST GID Startpoint ----------- ------------------------------------------------------------ 1 POINT ( 10.02000000 20.01000000) 2 POINT ZM ( 10.02000000 20.01000000 5.00000000 7.00000000) 2 record(s) selected.