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

ST_AsText

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) 


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