db2gse.ST_AsText´Â ±âÇÏÇÐ ¿ÀºêÁ§Æ®¸¦ ÃëÇØ Àß ¾Ë·ÁÁø ÅØ½ºÆ® Ç¥Çö½ÄÀ» ¸®ÅÏÇÕ´Ï´Ù.
±¸¹®
db2gse.ST_AsText(g db2gse.ST_Geometry)
¸®ÅÏ À¯Çü
Varchar(4000)
¿¹
´ÙÀ½ ½Ã³ª¸®¿¡¼´Â db2gse.ST_AsText ÇÔ¼ö°¡ HAZARDOUS_SITES À§Ä¡ Æ÷ÀÎÅ͸¦ ÀÌÀÇ ÅØ½ºÆ® ¼³¸íÀ¸·Î º¯È¯ÇÕ´Ï´Ù.
CREATE TABLE HAZARDOUS_SITES (site_id integer, name varchar(40), location db2gse.ST_Point); INSERT INTO HAZARDOUS_SITES VALUES (102, 'W. H. Kleenare Chemical Repository', db2gse.ST_PointFromText('point (1020.12 324.02)', db2gse.coordref()..srid(0))); SELECT site_id, name, cast(db2gse.ST_AsText(location) as varchar(40)) "Location" FROM HAZARDOUS_SITES;
SELECT¹®Àº ´ÙÀ½ÀÇ °á°ú ¼¼Æ®¸¦ ¸®ÅÏÇÕ´Ï´Ù.
SITE_ID Name Location ------- ------------------------------------ ---------------------------------- 102 W. H. Kleenare Chemical Repository POINT (1020.00000000 324.00000000)