´ÙÀ½ ±ÔÄ¢Àº °ø°£ °ü·Ã ¼ú¾î¸¦ »ç¿ëÇÏ¿© °ø°£ Á¶È¸¸¦ ÃÖÀûÈÇÏ·Á´Â °æ¿ì¿¡ Àû¿ëµË´Ï´Ù.
WHERE db2gse.ST_Within(c.location,:BayArea)=1
WHERE db2gse.ST_Within(c.location,:BayArea)=1
Ç¥ 4¿¡¼´Â °ø°£ »öÀÎÀ» ÀÌ¿ëÇϱâ À§ÇØ °ø°£ Á¶È¸¸¦ ÀÛ¼ºÇÒ ¶§ÀÇ ¿Ã¹Ù¸¥ ¹æ¹ý°ú Ʋ¸° ¹æ¹ýÀ» º¸¿© ÁÝ´Ï´Ù.
°ø°£ Á¶È¸ | ±ÔÄ¢ À§¹Ý |
---|---|
SELECT * FROM customers c WHERE db2gse.ST_Within(c.location,:BayArea)=1 | ÀÌ ¿¹¿¡¼´Â ¾î¶² Á¶°Çµµ À§¹ÝµÇÁö ¾Ê¾Ò½À´Ï´Ù. |
SELECT * FROM customers c WHERE db2gse.ST_Distance(c.location,:SanJose)<10 | ÀÌ ¿¹¿¡¼´Â ¾î¶² Á¶°Çµµ À§¹ÝµÇÁö ¾Ê¾Ò½À´Ï´Ù. |
SELECT * FROM customers c WHERE db2gse.ST_Length(c.location)>10 | ST_Length´Â °ø°£ °ü·Ã ¼ú¾î°¡ ¾Æ´Õ´Ï´Ù. |
SELECT * FROM customers c WHERE 1=db2gse.ST_Within(c.location,:BayArea) | ¼ú¾î´Â ºñ±³¹®ÀÇ ¿ÞÂÊÆí¿¡ ÀÖ¾î¾ß ÇÕ´Ï´Ù. |
SELECT * FROM customers c WHERE db2gse.ST_Within(c.location,:BayArea)=2 | µî½Ä ºñ±³¿¡¼´Â Á¤¼ö »ó¼ö 1À» »ç¿ëÇØ¾ß ÇÕ´Ï´Ù. |
SELECT * FROM customers c WHERE db2gse.ST_Within(:SanJose,:BayArea)=1 | ¼ú¾î¿¡ °Ë»ö ¸ñÇ¥·Î »ç¿ëµÈ °ø°£ Ä÷³ÀÌ ÀÖ¾î¾ß Çϰí ÇØ´ç Ä÷³¿¡ ´ëÇØ ÀÛ¼ºµÈ °ø°£ »öÀÎÀÌ ÀÖ¾î¾ß ÇÕ´Ï´Ù. (SanJose ¹× BayArea´Â °ø°£ Ä÷³ÀÌ ¾Æ´Ï¹Ç·Î ¿¬°üµÈ °ø°£ »öÀÎÀ» °¡Áú ¼ö ¾ø½À´Ï´Ù.) |