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

ST_StartPoint

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. 


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