ST_NumGeometries´Â ÄÝ·º¼ÇÀ» ÃëÇØ ÄÝ·º¼Ç ³»ÀÇ ±âÇÏÇÐ ¼ö¸¦ ¸®ÅÏÇÕ´Ï´Ù.
±¸¹®
db2gse.ST_NumGeometries(g db2gse.ST_GeomCollection)
¸®ÅÏ À¯Çü
Integer
¿¹
µµ½Ã °øÇÐÀÚ´Â °¢ ºôµù À§Ä¡¿Í ¿¬°üµÈ º°°³ ºôµùÀÇ ½ÇÁ¦ ¼ö¸¦ ¾Ë°í ÀÖ¾î¾ß ÇÕ´Ï´Ù.
ºôµù À§Ä¡´Â ´ÙÀ½ÀÇ CREATE TABLE¹®À¸·Î ÀÛ¼ºµÇ´Â BUILDINGFOOTPRINTS Å×ÀÌºí¿¡ ÀúÀåµË´Ï´Ù.
CREATE TABLE BUILDINGFOOTPRINTS ( building_id integer, lot_id integer, footprint db2gse.ST_MultiPolygon);
´ÙÀ½ÀÇ SELECT¹®Àº ST_NumGeometries ÇÔ¼ö¸¦ »ç¿ëÇÏ¿© °¢ ºôµùÀ» °íÀ¯ÇÏ°Ô ³ªÅ¸³»´Â BUILDING_ID¿Í °¢ À§Ä¡¿¡ ÀÖ´Â ºôµù ¼ö¸¦ ³ª¿ÇÕ´Ï´Ù.
SELECT building_id, db2gse.ST_NumGeometries (footprint) "Number of buildings" FROM BUILDINGFOOTPRINTS;