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

ST_NumPoints

ST_NumPoints´Â ¼±½ºÆ®¸µÀ» ÃëÇØ ÀÌÀÇ Á¡ ¼ö¸¦ ¸®ÅÏÇÕ´Ï´Ù.

±¸¹®

db2gse.ST_NumPoints(l db2gse.ST_LineString)

¸®ÅÏ À¯Çü

Integer

¿¹

´ÙÀ½ÀÇ CREATE TABLE¹®Àº NUMPOINT_TEST Å×À̺íÀ» ÀÛ¼ºÇÕ´Ï´Ù. GEOTYPE Ä÷³¿¡´Â G1 ±âÇÏÇÐ Ä÷³¿¡ ÀúÀåµÈ ±âÇÏÇÐ À¯ÇüÀÌ µé¾î ÀÖ½À´Ï´Ù.

CREATE TABLE NUMPOINTS_TEST (geotype varchar(12), g1 db2gse.ST_Geometry)

´ÙÀ½ÀÇ INSERT¹®Àº ¼±½ºÆ®¸µÀ» »ðÀÔÇÕ´Ï´Ù.

INSERT INTO NUMPOINTS_TEST VALUES( linestring,
db2gse.ST_LineFromText('linestring (10.02 20.01, 23.73 21.92)', 
db2gse.coordref()..srid(0)))

´ÙÀ½ÀÇ SELECT¹® ¹× ÇØ´ç °á°ú ¼¼Æ®¿¡¼­´Â ±âÇÏÇÐ À¯Çü°ú °¢°¢¿¡ Æ÷ÇÔµÈ Á¡ ¼ö¸¦ ³ª¿­ÇÕ´Ï´Ù.

SELECT geotype, db2gse.ST_NumPoints(g1)
FROM NUMPOINTS_TEST
 
GEOTYPE      Number of points
------------ ----------------
ST_linestring          2
  1 record(s) selected. 


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