| PostgreSQL 8.0.4 ʸ½ñ | ||||
|---|---|---|---|---|
| Á°¤Î¥Ú¡¼¥¸ | ´¬Ìᤷ | Âè 8¾Ï¥Ç¡¼¥¿·¿ | ÁáÁ÷¤ê | ¼¡¤Î¥Ú¡¼¥¸ |
´ö²¿¥Ç¡¼¥¿·¿¤Ï2¼¡¸µ¶õ´Ö¥ª¥Ö¥¸¥§¥¯¥È¤òɽ¸½¤·¤Þ¤¹¡£ ɽ8-16¤Ï¡¢PostgreSQL¤Ç»ÈÍѲÄǽ¤Ê´ö²¿¥Ç¡¼¥¿·¿¤òÎóµó¤·¤¿¤â¤Î¤Ç¤¹¡£ ¤â¤Ã¤È¤â´ðËܤȤʤ뷿¤Ïpoint¤Ç¡¢Á´¤Æ¤Î¾¤Î·¿¤Î´ðÁäò·ÁÀ®¤·¤Þ¤¹¡£
ɽ 8-16. ´ö²¿¥Ç¡¼¥¿·¿
| ·¿Ì¾ | ³ÊǼ¥µ¥¤¥º | ɽ¸½ | ÀâÌÀ |
|---|---|---|---|
| point | 16¥Ð¥¤¥È | Ê¿Ì̤ˤª¤±¤ëºÂɸÅÀ | (x,y) |
| line | 32¥Ð¥¤¥È | ̵¸Â¤ÎľÀþ (´°Á´¤Ë¤Ï¼ÂÁõ¤µ¤ì¤Æ¤¤¤Þ¤»¤ó) | ((x1,y1),(x2,y2)) |
| lseg | 32¥Ð¥¤¥È | ͸¤ÎÀþʬ | ((x1,y1),(x2,y2)) |
| box | 32¥Ð¥¤¥È | ¶ë·Á | ((x1,y1),(x2,y2)) |
| path | 16+16n¥Ð¥¤¥È | ÊÄ·ÐÏ©¡Ê¿³Ñ·Á¤ËÎà»÷¡Ë | ((x1,y1),...) |
| path | 16+16n¥Ð¥¤¥È | ³«·ÐÏ© | [(x1,y1),...] |
| polygon | 40+16n¥Ð¥¤¥È | ¿³Ñ·Á¡ÊÊÄ·ÐÏ©¤ËÎà»÷¡Ë | ((x1,y1),...) |
| circle | 24¥Ð¥¤¥È | ±ß | <(x,y),r>(Ãæ¿´¤ÈȾ·Â) |
³ÈÂç½Ì¾®¡¢ÊÑ·Á¡¢²óž¡¢¸òÅÀ¤Î»»½Ð¤È¤¤¤Ã¤¿ÍÍ¡¹¤Ê´ö²¿³ØÅªÁàºî¤ò¹Ô¤¦´Ø¿ô¤È±é»»»Ò¤Î½¸¹ç¤¬ËÉ٤˷¤Ã¤Æ¤¤¤Þ¤¹¡£ ¤³¤Î¤³¤È¤Ë¤Ä¤¤¤Æ¤Ï¹à9.10¤ËÀâÌÀ¤¬¤¢¤ê¤Þ¤¹¡£
ºÂɸÅÀ¤Ï´ö²¿¥Ç¡¼¥¿·¿¤Î´ðÁäȤʤë2¼¡¸µ¹½À®Í×ÁǤǤ¹¡£ point·¿¤ÎÃͤϼ¡¤Î¹½Ê¸¤Ç»ØÄꤵ¤ì¤Þ¤¹¡£
( x , y ) x , y
¤³¤³¤Çx¤Èy¤Ï¡¢¤½¤ì¤¾¤ì¤ÎºÂɸ¤òÉâÆ°¾®¿ôÅÀ¿ô¿ôÃͤÇɽ¤·¤¿¤â¤Î¤Ç¤¹¡£
Àþʬ¡Êlseg¡Ë¤ÏºÂɸÅÀ¤ÎÁȹ礻¤Çɽ¸½¤µ¤ì¤Þ¤¹¡£ lseg·¿¤ÎÃͤϼ¡¤Î¹½Ê¸¤Ç»ØÄꤵ¤ì¤Þ¤¹¡£
( ( x1 , y1 ) , ( x2 , y2 ) )
( x1 , y1 ) , ( x2 , y2 )
x1 , y1 , x2 , y2¤³¤³¤Ç¡¢(x1,y1)¤È(x2,y2)¤ÏÀþʬ¤Î½ªÃ¼ÅÀ¤Ç¤¹¡£
¶ë·Á¤Ï¡¢¶ë·Á¤ÎÂгÑÀþ¤Îξü¤ÎºÂɸÅÀ¤ÎÁȤ߹ç¤ï¤»¤Çɽ¤µ¤ì¤Þ¤¹¡£ box·¿¤ÎÃͤϰʲ¼¤Î¹½Ê¸¤Ç»ØÄꤵ¤ì¤Þ¤¹¡£
( ( x1 , y1 ) , ( x2 , y2 ) )
( x1 , y1 ) , ( x2 , y2 )
x1 , y1 , x2 , y2¤³¤³¤Ç(x1,y1)¤È(x2,y2)¤Ï¶ë·Á¤ÎÂгÑÀþ¤Îξü¤Ç¤¹¡£
¶ë·Á¤ÏºÇ½é¤Ë¼¨¤·¤¿¹½Ê¸¤Ç½ÐÎϤµ¤ì¤Þ¤¹¡£ ĺÅÀ¤Ï¡¢±¦¾å¤ÎĺÅÀ¤òºÇ½é¤Ë¡¢º¸²¼¤ÎĺÅÀ¤ò¤½¤Î¸å¤Ë³ÊǼ¤¹¤ë¤è¤¦ÆþÎÏ»þ¤Ëʤ٤é¤ì¤Þ¤¹¡£ ¶ë·Á¤Î¾¤ÎĺÅÀ¤òÆþÎϤ·¤Æ¤â¹½¤¤¤Þ¤»¤ó¤¬¡¢ÆþÎϤκ¸²¼¤È±¦¾å¤ÎĺÅÀ¤«¤é¶ë·Á¤¬·èÄꤵ¤ì¡¢¤½¤·¤Æ³ÊǼ¤µ¤ì¤Þ¤¹¡£
·ÐÏ©¤ÏÀܳ¤·¤Æ¤¤¤ëºÂɸÅÀ¤Î¥ê¥¹¥È¤Çɽ¸½¤µ¤ì¤Þ¤¹¡£ ·ÐÏ©¤ÏºÇ½é¤ÎºÂɸÅÀ¤ÈºÇ¸å¤ÎºÂɸÅÀ¤¬Àܳ¤µ¤ì¤Æ¤¤¤Ê¤¤¤È¤ß¤Ê¤µ¤ì¤ë³«¤¤¤Æ¤¤¤ë¾õÂÖ¤«¡¢ºÇ½é¤ÎºÂɸÅÀ¤ÈºÇ¸å¤ÎºÂɸÅÀ¤¬Àܳ¤µ¤ì¤Æ¤¤¤ë¤È¤ß¤Ê¤µ¤ì¤ëÊĤ¸¤¿¾õÂÖ¤«¤Î¤¤¤º¤ì¤«¤Ç¤¹¡£
path·¿¤ÎÃͤϼ¡¤Î¹½Ê¸¤Ç»ØÄꤵ¤ì¤Þ¤¹¡£
( ( x1 , y1 ) , ... , ( xn , yn ) )
[ ( x1 , y1 ) , ... , ( xn , yn ) ]
( x1 , y1 ) , ... , ( xn , yn )
( x1 , y1 , ... , xn , yn )
x1 , y1 , ... , xn , yn ¤³¤³¤Ç¡¢³ÆºÂɸÅÀ¤Ï¡¢·ÐÏ©¤ò¹½À®¤¹¤ëÀþʬ¤Î½ªÃ¼ÅÀ¤Ç¤¹¡£ Âç³ç¸Ì([])¤Ï³«·ÐÏ©¤ò¡¢³ç¸Ì(())¤ÏÊÄ·ÐÏ©¤ò¼¨¤·¤Þ¤¹¡£
·ÐÏ©¤ÏºÇ½é¤Î¹½Ê¸¤Ç½ÐÎϤµ¤ì¤Þ¤¹¡£
¿³Ñ·Á¤ÏºÂɸÅÀ(¿³Ñ·Á¤ÎĺÅÀ)¤Î¥ê¥¹¥È¤Çɽ¸½¤µ¤ì¤Þ¤¹¡£ ¿³Ñ·Á¤Ï¤¿¤Ö¤óÊÄ·ÐÏ©¤ÈƱ¤¸¤È¹Í¤¨¤é¤ì¤ë¤«¤â¤·¤ì¤Þ¤»¤ó¤¬¡¢°Û¤Ê¤Ã¤¿Êý¼°¤Ç³ÊǼ¤µ¤ì¤ë¤ÈƱ»þ¤Ë¤½¤ì¤¾¤ìÆÈ¼«¤Ë»Ù±ç¤¹¤ë¥ë¡¼¥Á¥ó°ì¼°¤ò»ý¤Ã¤Æ¤¤¤Þ¤¹¡£
polygon·¿¤ÎÃͤϼ¡¤Î¹½Ê¸¤Ç»ØÄꤵ¤ì¤Þ¤¹¡£
( ( x1 , y1 ) , ... , ( xn , yn ) )
( x1 , y1 ) , ... , ( xn , yn )
( x1 , y1 , ... , xn , yn )
x1 , y1 , ... , xn , yn ³ÆºÂɸÅÀ¤Ï¿³Ñ·Á¤Î¶³¦¤ò¹½À®¤¹¤ëÀþʬ¤Î½ªÃ¼ÅÀ¤Ç¤¹¡£
¿³Ñ·Á¤ÏºÇ½é¤Î¹½Ê¸¤Ç½ÐÎϤµ¤ì¤Þ¤¹¡£
| Á°¤Î¥Ú¡¼¥¸ | ¥Û¡¼¥à | ¼¡¤Î¥Ú¡¼¥¸ |
| ÏÀÍýÃͥǡ¼¥¿·¿ | ¾å¤ËÌá¤ë | ¥Í¥Ã¥È¥ï¡¼¥¯¥¢¥É¥ì¥¹·¿ |