ST_SRID´Â ±âÇÏÇÐ ¿ÀºêÁ§Æ®¸¦ ÃëÇØ ÀÌÀÇ °ø°£ ÂüÁ¶ ½Ã½ºÅÛ ½Äº°ÀÚ¸¦ ¸®ÅÏÇÕ´Ï´Ù.
±¸¹®
db2gse.ST_SRID(g1 db2gse.ST_Geometry)
¸®ÅÏ À¯Çü
Integer
¿¹
ST_SRID ÇÔ¼ö´Â ST_Geometry °ª°ú ¿¬°üµÈ °ø°£ ÂüÁ¶ ½Ã½ºÅÛ °ø°£ ÂüÁ¶ ½Ã½ºÅÛ ½Äº°ÀÚ¸¦ ¸®ÅÏÇÕ´Ï´Ù.
¿¹¸¦ µé¾î, ±âÇÏÇÐ À¯ÇüÀº CREATE TABLE¹®¿¡ »ç¿ëµË´Ï´Ù.
CREATE TABLE SRID_TEST(g1 db2gse.ST_Geometry)
´ÙÀ½ INSERT¹®¿¡¼´Â ÁÂÇ¥ 10.01,50.76¿¡ ³õÀÎ Á¡ ±âÇÏÇÐÀÌ ±âÇÏÇÐ Ä÷³ G1¿¡ »ðÀԵ˴ϴÙ. ST_PointFromText ÇÔ¼ö°¡ Á¡ ±âÇÏÇÐÀ» ÀÛ¼ºÇÒ ¶§, srid °ª 1À» ÁöÁ¤ÇÕ´Ï´Ù.
INSERT INTO SRID_TEST VALUES (db2gse.ST_PointFromText('point(10.01 50.76)', db2gse.coordref()..srid(0)))
ST_SRID ÇÔ¼ö´Â ´ÙÀ½ SELECT¹®°ú ÇØ´ç °á°ú ¼¼Æ®¿¡¼ ¼³¸íÇÑ´ë·Î ¹æ±Ý ÀÔ·ÂµÈ ±âÇÏÇÐÀÇ °ø°£ ÂüÁ¶ ½Ã½ºÅÛ ½Äº°ÀÚ¸¦ ¸®ÅÏÇÕ´Ï´Ù.
SELECT db2gse.ST_SRID(g1) FROM SRID_TEST g1 -------------- 0