| PostgreSQL 7.4.6 ʸ½ñ | ||||
|---|---|---|---|---|
| Á°¤Î¥Ú¡¼¥¸ | ´¬Ìᤷ | Âè 9¾Ï´Ø¿ô¤È±é»»»Ò | ÁáÁ÷¤ê | ¼¡¤Î¥Ú¡¼¥¸ |
PostgreSQL¤Ë¤Ï¡¢¥Ñ¥¿¡¼¥ó¥Þ¥Ã¥Á¥ó¥°¤ò¹Ô¤¦¤ËºÝ¤·¤Æ3¤Ä¤Î°Û¤Ê¤Ã¤¿¼êË¡¤¬¤¢¤ê¤Þ¤¹¡£ ÅÁÅýŪ¤ÊSQL¤ÎLIKE±é»»»Ò¡¢¤³¤ì¤è¤ê¿·¤·¤¤SQL99¤ÎSIMILAR TO±é»»»Ò¡¢¤ª¤è¤ÓPOSIXÍͼ°¤ÎÀµµ¬É½¸½¤Ç¤¹¡£ ¹¹¤Ë¡¢SQL99Íͼ°¤â¤·¤¯¤ÏPOSIXÍͼ°Àµµ¬É½¸½¤ò»È¤Ã¤Æ¡¢¥Ñ¥¿¡¼¥ó¥Þ¥Ã¥Á¥ó¥°´Ø¿ôsubstring¤ò»ÈÍѤ¹¤ë¤³¤È¤â²Äǽ¤Ç¤¹¡£
¥Æ¥£¥Ã¥×: ¾åµ¤Î¼êË¡¤Ç¤Ï¸¡º÷¤Ç¤¤Ê¤¤¤è¤¦¤Ê¥Ñ¥¿¡¼¥ó¥Þ¥Ã¥Á¥ó¥°¤¬É¬Íפʾì¹ç¤Ï¡¢Perl¤â¤·¤¯¤ÏTcl¤Ç¥æ¡¼¥¶ÄêµÁ´Ø¿ô¤òºîÀ®¤¹¤ë¤³¤È¤ò¸¡Æ¤¤·¤Æ¤¯¤À¤µ¤¤¡£
string LIKE pattern [ESCAPE escape-character] string NOT LIKE pattern [ESCAPE escape-character]
¤½¤ì¤¾¤ì¤Îpattern¤Ï¡¢Ê¸»úÎó¤Î½¸¹ç¤òÄêµÁ¤·¤Þ¤¹¡£ LIKE¼°¤Ïpattern¤Ë¤è¤Ã¤Æ¼¨¤µ¤ì¤ëʸ»úÎó¤Î½¸¹ç¤Ëstring¤¬´Þ¤Þ¤ì¤Æ¤¤¤ì¤Ð¿¿¤òÊÖ¤·¤Þ¤¹¡£ (ÁÛÁü¤µ¤ì¤ë¤È¤ª¤ê¡¢NOT LIKE¼°¤ÏLIKE¼°¤¬¿¿¤òÊÖ¤¹¾ì¹ç¤Ë¤Ïµ¶¤òÊÖ¤·¡¢¤½¤ÎµÕ¤â¤Þ¤¿Æ±¤¸¤Ç¤¹¡£ ƱÅù¤Î¼°¤È¤·¤ÆNOT (string LIKE pattern)¤È¤âɽ¸½¤Ç¤¤Þ¤¹¡£)
pattern¤¬¥Ñ¡¼¥»¥ó¥Èµ¹æ¤â¤·¤¯¤Ï¥¢¥ó¥À¡¼¥¹¥³¥¢¤ò´Þ¤ó¤Ç¤¤¤Ê¤¤¾ì¹çpattern¤Ï¼«¿È¤Îʸ»úÎ󤽤Τâ¤Î¤Ç¤¹¡£ ¤³¤Î¾ì¹çLIKE¼°¤ÏÅù¹æ±é»»»Ò¤Î¤è¤¦¤Ë¿¶Éñ¤¤¤Þ¤¹¡£ pattern¤ÎÃæ¤Ë¤¢¤ë¥¢¥ó¥À¡¼¥¹¥³¥¢(_)¤ÏǤ°Õ¤Î°ìʸ»ú¤È¤Î¥Þ¥Ã¥Á¤ò°ÕÌ£¤·¡¢¥Ñ¡¼¥»¥ó¥Èµ¹æ(%)¤Ï0ʸ»ú°Ê¾å¤Îʸ»úÎó¤È¤Î¥Þ¥Ã¥Á¤ò°ÕÌ£¤·¤Þ¤¹¡£
°Ê²¼¤Ë¤¤¤¯¤Ä¤«Îã¤ò¼¨¤·¤Þ¤¹¡£
'abc' LIKE 'abc' true 'abc' LIKE 'a%' true 'abc' LIKE '_b_' true 'abc' LIKE 'c' false
LIKE¤Ë¤è¤ë¥Ñ¥¿¡¼¥ó¥Þ¥Ã¥Á¤Ï¾ï¤Ëʸ»úÎóÁ´ÂΤËÂФ·¤Æ¹Ô¤ï¤ì¤Þ¤¹¡£ ¤Ç¤¹¤«¤é¡¢Ê¸»úÎóÆâ¤Î¤¤¤«¤Ê¤ë°ÌÃ֤ˤª¤¤¤Æ¤â¥Ñ¥¿¡¼¥ó¥Þ¥Ã¥Á¤µ¤»¤ë¤Ë¤Ï¥Ñ¡¼¥»¥ó¥Èµ¹æ¤òÀèƬ¤ÈËöÈø¤ËÉÕ¤±¤ëɬÍפ¬¤¢¤ê¤Þ¤¹¡£
¥¢¥ó¥À¡¼¥¹¥³¥¢¤ä¥Ñ¡¼¥»¥ó¥Èµ¹æ¤È¤¤¤¦¥ê¥Æ¥é¥ë¤ò¾¤Îʸ»ú¤Î¥Þ¥Ã¥Á¥ó¥°¤Ë»ÈÍѤ¹¤ë¤Î¤Ç¤Ï¤Ê¤¯¡¢¤½¤Î¤â¤Î¤Ë¥Þ¥Ã¥Á¤µ¤»¤¿¤¤¾ì¹ç¤Ë¤Ï¡¢pattern¤ÎÃæ¤Î¤½¤ì¤¾¤ì¤Î¥¢¥ó¥À¡¼¥¹¥³¥¢¤È¥Ñ¡¼¥»¥ó¥Èµ¹æ¤ÎÁ°¤Ë¥¨¥¹¥±¡¼¥×ʸ»ú¤òÉÕ¤±¤Ê¤±¤ì¤Ð¤Ê¤ê¤Þ¤»¤ó¡£ ¥Ç¥Õ¥©¥ë¥È¤Î¥¨¥¹¥±¡¼¥×ʸ»ú¤Ï¥Ð¥Ã¥¯¥¹¥é¥Ã¥·¥å¤Ç¤¹¤¬¡¢ESCAPE¶ç¤Ç¾¤Îʸ»ú¤ò»ØÄꤹ¤ë¤³¤È¤¬¤Ç¤¤Þ¤¹¡£ ¥¨¥¹¥±¡¼¥×ʸ»ú¤½¤Î¤â¤Î¤ò¥Þ¥Ã¥Á¤µ¤»¤ë¤Ë¤Ï¥¨¥¹¥±¡¼¥×ʸ»ú¤ò¤Õ¤¿¤Ä½ñ¤¤Þ¤¹¡£
¥ê¥Æ¥é¥ëʸ»úÎó¤Ë¤ª¤¤¤Æ¥Ð¥Ã¥¯¥¹¥é¥Ã¥·¥å¤Ë¤Ï»Ï¤á¤«¤éÆÃÊ̤ʰÕÌ£¹ç¤¤¤¬¤¢¤ë¤Î¤Ç¡¢¥Ð¥Ã¥¯¥¹¥é¥Ã¥·¥å¤ò´Þ¤ó¤À¥Ñ¥¿¡¼¥óÄê¿ô¤òµ½Ò¤¹¤ë»þ¤ÏÌ䤤¹ç¤ï¤»¤ÎÃæ¤Ç2¤Ä¤Î¥Ð¥Ã¥¯¥¹¥é¥Ã¥·¥å¤òµ½Ò¤¹¤ëɬÍפ¬¤¢¤ë¤³¤È¤ËÃí°Õ¤·¤Æ¤¯¤À¤µ¤¤¡£ ¤·¤¿¤¬¤Ã¤Æ¡¢¼ÂºÝ¤Ë¥Ð¥Ã¥¯¥¹¥é¥Ã¥·¥å¤½¤Î¤â¤Î¤Ë¥Þ¥Ã¥Á¤¹¤ë¥Ñ¥¿¡¼¥ó¤òµ½Ò¤¹¤ë¤Ë¤Ï¡¢Ê¸¤ÎÃæ¤Ç¥Ð¥Ã¥¯¥¹¥é¥Ã¥·¥å¤ò4¤Äµ½Ò¤¹¤ëɬÍפ¬¤¢¤ê¤Þ¤¹¡£ ESCAPE¶ç¤Ç¾¤Î¥¨¥¹¥±¡¼¥×ʸ»ú¤òÁªÂò¤¹¤ì¤Ð¤³¤Î¤è¤¦¤Ê¾õ¶·¤ò²óÈò¤Ç¤¡¢¥Ð¥Ã¥¯¥¹¥é¥Ã¥·¥å¤ÏLIKE¼°¤Ë¤È¤êÆüì¤Êʸ»ú¤Ç¤Ï¤Ê¤¯¤Ê¤ê¤Þ¤¹¡£ (¤È¤Ï¤¤¤Ã¤Æ¤â¡¢¥ê¥Æ¥é¥ëʸ»úÎó¥Ñ¡¼¥µ¤Ë¤È¤Ã¤Æ¤Ï°ÍÁ³¤È¤·¤ÆÆüìʸ»ú¤Ê¤Î¤Ç¡¢¤ä¤Ï¤ê2¤Ä¤ÏɬÍפǤ¹¡£)
Ʊ»þ¤ËESCAPE ''¤Èµ½Ò¤¹¤ë¤³¤È¤Ç¥¨¥¹¥±¡¼¥×ʸ»ú¤òÁªÂò¤·¤Ê¤¤¤³¤È¤â²Äǽ¤Ç¤¹¡£ ¤³¤ì¤Ë¤è¤ê¡¢»ö¼Â¾å¥¨¥¹¥±¡¼¥×µ¡¹½¤¬Æ¯¤«¤Ê¤¯¤Ê¤ê¤Þ¤¹¡£ ¤Ä¤Þ¤ê¡¢¥Ñ¥¿¡¼¥óÆâ¤Î¥¢¥ó¥À¡¼¥¹¥³¥¢¤ª¤è¤Ó¥Ñ¡¼¥»¥ó¥Èµ¹æ¤ÎÆÃÊ̤ʰÕÌ£¤ò²ò½ü¤¹¤ë¤³¤È¤Ï¤Ç¤¤Ê¤¯¤Ê¤ê¤Þ¤¹¡£
¸½ºß¤Î¥í¥±¡¼¥ë¤Ë½¾¤Ã¤ÆÂçʸ»ú¾®Ê¸»ú¤ò¶èÊ̤·¤Ê¤¤¥Þ¥Ã¥Á¤ò¹Ô¤¦¤Î¤Ç¤¢¤ì¤ÐLIKE¤ÎÂؤï¤ê¤ËILIKE¥¡¼¥ï¡¼¥É¤ò»È¤¦¤³¤È¤¬¤Ç¤¤Þ¤¹¡£ ¤³¤ì¤Ïɸ½àSQL¤Ç¤Ï¤Ê¤¯¡¢PostgreSQL¤Î³ÈÄ¥¤Ç¤¹¡£
~~±é»»»Ò¤ÏLIKE¼°¤ÈÅù²Á¤Ç¡¢~~*¤ÏILIKE¤ËÂбþ¤·¤Þ¤¹¡£ ¤Þ¤¿NOT LIKE¤ª¤è¤ÓNOT ILIKE¤òɽ¤¹!~~¤ª¤è¤Ó!~~*±é»»»Ò¤¬¤¢¤ê¤Þ¤¹¡£ ¤³¤ì¤é¤¹¤Ù¤Æ¤Î±é»»»Ò¤ÏPostgreSQL¸ÇͤΤâ¤Î¤Ç¤¹¡£
string SIMILAR TO pattern [ESCAPE escape-character] string NOT SIMILAR TO pattern [ESCAPE escape-character]
SIMILAR TO±é»»»Ò¤Ï¡¢¤½¤Î¥Ñ¥¿¡¼¥ó¤¬Í¿¤¨¤é¤ì¤¿Ê¸»úÎó¤Ë¥Þ¥Ã¥Á¤¹¤ë¤«¤É¤¦¤«¤Ë¤è¤ê¡¢¿¿¤â¤·¤¯¤Ïµ¶¤òÊÖ¤·¤Þ¤¹¡£ ¤³¤ì¤Ï¡¢SQL99¤ÎÀµµ¬É½¸½ÄêµÁ¤ò»ÈÍѤ·¤Æ¥Ñ¥¿¡¼¥ó¤ò²ò¼á¤¹¤ë¤È¤¤¤¦ÅÀ°Ê³°¤Ï¡¢LIKE¤ËÈó¾ï¤Ë¤è¤¯»÷¤Æ¤¤¤Þ¤¹¡£ SQL99¤ÎÀµµ¬É½¸½¤Ï¡¢LIKEɽµ¤È°ìÈÌŪ¤ÊÀµµ¬É½¸½¤Îɽµ¤È¤òº®¤¼¹ç¤ï¤»¤¿¤è¤¦¤Ê¤â¤Î¤Ë¤Ê¤Ã¤Æ¤¤¤Þ¤¹¡£
LIKE¤ÈƱÍÍ¡¢SIMILAR TO±é»»»Ò¤Ï¡¢¤½¤Î¥Ñ¥¿¡¼¥ó¤¬Ê¸»úÎóÁ´ÂΤ˥ޥåÁ¤·¤¿¾ì¹ç¤Î¤ß½èÍý¤ò¹Ô¤Ê¤¤¤Þ¤¹¡£ ¤³¤ì¤Ï¡¢¥Ñ¥¿¡¼¥ó¤¬Ê¸»úÎó¤Î°ìÉôʬ¤Ç¤¢¤Ã¤Æ¤â¥Þ¥Ã¥Á¤¹¤ë¡¢°ìÈÌŪ¤ÊÀµµ¬É½¸½¤Î½èÍý¤È¤Ï°Û¤Ê¤Ã¤Æ¤¤¤Þ¤¹¡£ ¤Þ¤¿¡¢LIKE¤ÈƱÍÍ¡¢SIMILAR TO¤Ç¤Ï¡¢%¤ª¤è¤Ó_¤ò¡¢¤½¤ì¤¾¤ìǤ°Õ¤Îʸ»úÎ󤪤è¤ÓǤ°Õ¤Îñ°ìʸ»ú¤ò°ÕÌ£¤¹¤ë¥ï¥¤¥ë¥É¥«¡¼¥Éʸ»ú¤È¤·¤Æ»ÈÍѤ·¤Þ¤¹(¤³¤ì¤é¤Ï¡¢POSIXÀµµ¬É½¸½¤Ç¤Î.*¤ª¤è¤Ó.¤ËÁêÅö¤·¤Þ¤¹)¡£
LIKE¤«¤é¼è¤êÆþ¤ì¤¿¾åµ¤Îµ¡Ç½¤Ë²Ã¤¨¡¢SIMILAR TO¤Ç¤Ï¡¢°Ê²¼¤Î¤è¤¦¤ËPOSIXÀµµ¬É½¸½¤«¤é¼è¤êÆþ¤ì¤¿¥Ñ¥¿¡¼¥ó¥Þ¥Ã¥Á¥ó¥°¥á¥¿Ê¸»ú¤â¥µ¥Ý¡¼¥È¤·¤Æ¤¤¤Þ¤¹¡£
|¤Ï¡¢Æó¼ÔÂò°ì(2¤Ä¤ÎÁªÂò»è¤Î¤¦¤Á¤¤¤º¤ì¤«)¤ò°ÕÌ£¤·¤Þ¤¹¡£
*¤Ï¡¢Ä¾Á°¤Î¥¢¥¤¥Æ¥à¤Î0²ó°Ê¾å¤Î·«¤êÊÖ¤·¤ò°ÕÌ£¤·¤Þ¤¹¡£
+¤Ï¡¢Ä¾Á°¤Î¥¢¥¤¥Æ¥à¤Î1²ó°Ê¾å¤Î·«¤êÊÖ¤·¤ò°ÕÌ£¤·¤Þ¤¹¡£
³ç¸Ì()¤Ï¡¢¥¢¥¤¥Æ¥à¤ò1¤Ä¤ÎÏÀÍý¥¢¥¤¥Æ¥à¤Ë¥°¥ë¡¼¥×²½¤¹¤ë¤³¤È¤¬¤Ç¤¤Þ¤¹¡£
Âç³ç¸Ì¼°[...]¤Ï¡¢POSIXÀµµ¬É½¸½¤ÈƱÍͤËʸ»ú¥¯¥é¥¹¤ò»ØÄꤷ¤Þ¤¹¡£
¥Ð¥¦¥ó¥ÉÈ¿Éü(?¤ª¤è¤Ó{...}) ¤Ï¡¢POSIX¤Ë¤Ï¤¢¤ê¤Þ¤¹¤¬¡¢¤³¤³¤Ç¤Ï»ÈÍѤǤ¤Ê¤¤¤³¤È¤ËÃí°Õ¤·¤Æ¤¯¤À¤µ¤¤¡£ ¤Þ¤¿¡¢¥É¥Ã¥È(.)¤Ï¥á¥¿Ê¸»ú¤Ç¤Ï¤¢¤ê¤Þ¤»¤ó¡£
LIKE¤ÈƱÍÍ¡¢¥Ð¥Ã¥¯¥¹¥é¥Ã¥·¥å¤Ï¤¹¤Ù¤Æ¤Î¥á¥¿Ê¸»ú¤ÎÆüì¤Ê°ÕÌ£¤ò̵¸ú¤Ë¤·¤Þ¤¹¡£ ¤Þ¤¿¡¢°Û¤Ê¤ë¥¨¥¹¥±¡¼¥×ʸ»ú¤òESCAPE¤Ç»ØÄꤹ¤ë¤³¤È¤¬²Äǽ¤Ç¤¹¡£
°Ê²¼¤Ë¤¤¤¯¤Ä¤«Îã¤ò¼¨¤·¤Þ¤¹¡£
'abc' SIMILAR TO 'abc' true 'abc' SIMILAR TO 'a' false 'abc' SIMILAR TO '%(b|d)%' true 'abc' SIMILAR TO '(b|c)%' false
3¤Ä¤Î¥Ñ¥é¥á¡¼¥¿¤ò»ý¤Äsubstring´Ø¿ô¡¢substring(string from pattern for escape-character)¤ò»ÈÍѤ·¤Æ¡¢SQL99Àµµ¬É½¸½¥Ñ¥¿¡¼¥ó¤Ë¥Þ¥Ã¥Á¤¹¤ëÉôʬʸ»úÎó¤ò¼è¤ê½Ð¤¹¤³¤È¤¬¤Ç¤¤Þ¤¹¡£ SIMILAR TO¤ÈƱÍÍ¡¢»ØÄꤷ¤¿¥Ñ¥¿¡¼¥ó¤¬¥Ç¡¼¥¿Ê¸»úÎóÁ´ÂΤ˥ޥåÁ¤¹¤ëɬÍפ¬¤¢¤ê¤Þ¤¹¡£ ¥Þ¥Ã¥Á¤·¤Ê¤¤¾ì¹ç¡¢´Ø¿ô¤Ï½ªÎ»¤·¡¢NULL¤òÊÖ¤·¤Þ¤¹¡£ ¥Þ¥Ã¥Á¤·¤¿¾ì¹ç¤ËÊÖ¤µ¤ì¤ë¤Ù¤¥Ñ¥¿¡¼¥ó¤Î°ìÉô¤ò¼¨¤¹¤¿¤á¤Ë¡¢¥¨¥¹¥±¡¼¥×ʸ»ú¤Î¸å¤ËÆó½Å°úÍÑÉä(")¤ò¤Ä¤Ê¤²¤¿¤â¤Î¤ò2¤Ä¥Ñ¥¿¡¼¥ó¤Ë´Þ¤á¤ëɬÍפ¬¤¢¤ê¤Þ¤¹¡£ ¤³¤ì¤é¤Î°õ¤Ç°Ï¤ï¤ì¤¿¥Ñ¥¿¡¼¥ó¤Î°ìÉô¤Ë¥Þ¥Ã¥Á¤¹¤ë¥Æ¥¥¹¥È¤¬ÊÖ¤µ¤ì¤Þ¤¹¡£
°Ê²¼¤Ë¤¤¤¯¤Ä¤«Îã¤ò¼¨¤·¤Þ¤¹¡£
substring('foobar' from '%#"o_b#"%' for '#') oob
substring('foobar' from '#"o_b#"%' for '#') NULL
ɽ9-11¤Ë¡¢POSIXÀµµ¬É½¸½¤ò»È¤Ã¤¿¥Ñ¥¿¡¼¥ó¥Þ¥Ã¥Á¥ó¥°¤Ë»ÈÍѲÄǽ¤Ê±é»»»Ò¤òÎóµó¤·¤Þ¤¹¡£
ɽ 9-11. Àµµ¬É½¸½¥Þ¥Ã¥Á±é»»»Ò
| ±é»»»Ò | ÀâÌÀ | Îã |
|---|---|---|
| ~ | Àµµ¬É½¸½¤Ë¥Þ¥Ã¥Á¡¢Âçʸ»ú¾®Ê¸»ú¤Î¶èÊ̤¢¤ê | 'thomas' ~ '.*thomas.*' |
| ~* | Àµµ¬É½¸½¤Ë¥Þ¥Ã¥Á¡¢Âçʸ»ú¾®Ê¸»ú¤Î¶èÊ̤ʤ· | 'thomas' ~* '.*Thomas.*' |
| !~ | Àµµ¬É½¸½¤Ë¥Þ¥Ã¥Á¤·¤Ê¤¤¡¢Âçʸ»ú¾®Ê¸»ú¤Î¶èÊ̤¢¤ê | 'thomas' !~ '.*Thomas.*' |
| !~* | Àµµ¬É½¸½¤Ë¥Þ¥Ã¥Á¤·¤Ê¤¤¡¢Âçʸ»ú¾®Ê¸»ú¤Î¶èÊ̤ʤ· | 'thomas' !~* '.*vadim.*' |
POSIXÀµµ¬É½¸½¤Ï¡¢¥Ñ¥¿¡¼¥ó¥Þ¥Ã¥Á¥ó¥°¤È¤¤¤¦°ÕÌ£¹ç¤¤¤Ç¤Ï¡¢LIKE¤ª¤è¤ÓSIMILAR TO±é»»»Ò¤è¤ê¤â¤µ¤é¤Ë¶¯ÎϤǤ¹¡£ egrep¡¢sed¡¢¤¢¤ë¤¤¤Ïawk¤Î¤è¤¦¤Ê¿¤¯¤ÎUnix¥Ä¡¼¥ë¤Ï¤³¤³¤Ç²òÀ⤷¤Æ¤¤¤ë¤Î¤ÈÎà»÷¤·¤¿¥Ñ¥¿¡¼¥ó¥Þ¥Ã¥Á¥ó¥°¸À¸ì¤ò»ÈÍѤ·¤Æ¤¤¤Þ¤¹¡£
Àµµ¬É½¸½¤È¤Ïʸ»úÎó¤Î½¸¹ç(Àµµ¬½¸¹ç)¤Î´Êά¤µ¤ì¤¿ÄêµÁ¤Ç¤¢¤ëʸ»ú¤¬Ï¢¤Ê¤Ã¤Æ¤¤¤ë¤â¤Î¤Ç¤¹¡£ ¤¢¤ëʸ»úÎó¤¬Àµµ¬É½¸½¤Çµ½Ò¤µ¤ì¤¿Àµµ¬½¸¹ç¤ÎÍ×ÁǤˤʤäƤ¤¤ì¤Ð¡¢¤½¤Îʸ»úÎó¤ÏÀµµ¬É½¸½¤Ë¥Þ¥Ã¥Á¤·¤Æ¤¤¤ë¤È¸Æ¤Ð¤ì¤Þ¤¹¡£ LIKE¤ÈƱÍÍ¡¢Àµµ¬É½¸½¸À¸ì¤ÇÆüìʸ»ú¤È¤µ¤ì¤Æ¤¤¤ë¤â¤Î°Ê³°¡¢¥Ñ¥¿¡¼¥óʸ»ú¤Ïʸ»úÎó¤È´°Á´¤Ë¥Þ¥Ã¥Á¤µ¤ì¤Þ¤¹¡£ ¤È¤Ï¤¤¤Ã¤Æ¤âÀµµ¬É½¸½¤ÏLIKE´Ø¿ô¤¬»ÈÍѤ¹¤ë¤â¤Î¤È°Û¤Ê¤ëÆüìʸ»ú¤ò»ÈÍѤ·¤Þ¤¹¡£ LIKE´Ø¿ô¤Î¥Ñ¥¿¡¼¥ó¤È°ã¤Ã¤ÆÀµµ¬É½¸½¤Ï¡¢ÌÀ¼¨Åª¤ËÀµµ¬É½¸½¤¬Ê¸»úÎó¤ÎºÇ½é¤Þ¤¿¤ÏºÇ¸å¤«¤é¤È°ÌÃÖ»ØÄꤵ¤ì¤Æ¤¤¤Ê¤¤¸Â¤êʸ»úÎóÆâ¤Î¤É¤Î°ÌÃ֤Ǥâ¥Þ¥Ã¥Á¤ò¹Ô¤¨¤Þ¤¹¡£
°Ê²¼¤Ë¤¤¤¯¤Ä¤«Îã¤ò¼¨¤·¤Þ¤¹¡£
'abc' ~ 'abc' true 'abc' ~ '^a' true 'abc' ~ '(b|d)' true 'abc' ~ '^(b|c)' false
2¤Ä¤Î¥Ñ¥é¥á¡¼¥¿¤ò»ý¤Äsubstring´Ø¿ô¡¢substring(string from pattern)¤ò»ÈÍѤ·¤Æ¡¢POSIXÀµµ¬É½¸½¥Ñ¥¿¡¼¥ó¤Ë¥Þ¥Ã¥Á¤¹¤ëÉôʬʸ»úÎó¤ò¼è¤ê½Ð¤¹¤³¤È¤¬¤Ç¤¤Þ¤¹¡£ ¤³¤Î´Ø¿ô¤Ï¡¢¥Þ¥Ã¥Á¤¹¤ë¤â¤Î¤¬¤Ê¤¤¾ì¹ç¤Ë¤ÏNULL¤òÊÖ¤·¡¢¤¢¤ë¾ì¹ç¤Ï¥Ñ¥¿¡¼¥ó¤Ë¥Þ¥Ã¥Á¤·¤¿¥Æ¥¥¹¥È¤Î°ìÉô¤òÊÖ¤·¤Þ¤¹¡£ ¤·¤«¤·¡¢Ç¤°Õ¤Î³ç¸Ì¤ò»ý¤Ä¥Ñ¥¿¡¼¥ó¤Î¾ì¹ç¡¢ºÇ½é¤Î³ç¸ÌÆâÉôʬÀµµ¬É½¸½(º¸³ç¸Ì¤¬ºÇ½é¤ËÍè¤ë¤â¤Î)¤Ë¥Þ¥Ã¥Á¤¹¤ë¥Æ¥¥¹¥È¤Î°ìÉô¤¬ÊÖ¤µ¤ì¤Þ¤¹¡£ ¤³¤ÎÎã³°¤òµ¯¤³¤µ¤º¤Ë¥Ñ¥¿¡¼¥óÃæ¤Ë³ç¸Ì¤ò»ÈÍѤ·¤¿¤¤¤Î¤Ç¤¢¤ì¤Ð¡¢¾ï¤ËÀµµ¬É½¸½Á´ÂΤò³ç¸Ì¤Ç°Ï¤à¤³¤È¤¬¤Ç¤¤Þ¤¹¡£
°Ê²¼¤Ë¤¤¤¯¤Ä¤«Îã¤ò¼¨¤·¤Þ¤¹¡£
substring('foobar' from 'o.b') oob
substring('foobar' from 'o(.)b') o
PostgreSQL¤ÎÀµµ¬É½¸½¤ÏHenry Spencer¤Ë¤è¤êºîÀ®¤µ¤ì¤¿¥Ñ¥Ã¥±¡¼¥¸¤ò»ÈÍѤ·¤Æ¼ÂÁõ¤µ¤ì¤Þ¤·¤¿¡£ °Ê²¼¤ÎÀµµ¬É½¸½¤ÎÀâÌÀ¤Î¿¤¯¤Ï¡¢¤³¤Î¥Ñ¥Ã¥±¡¼¥¸¤Î¥Þ¥Ë¥å¥¢¥ë¹àÌܤ«¤é¥³¥Ô¡¼¤µ¤ì¤Þ¤·¤¿¡£
POSIX 1003.2¤ÎÄêµÁ¤Ë¤è¤ë¤È¡¢Àµµ¬É½¸½(RE)¤Ë¤Ï2¤Ä¤Î·Á¼°¤¬¤¢¤ë¤È¤µ¤ì¤Þ¤¹¡£ ³ÈÄ¥RE¤â¤·¤¯¤ÏERE(Âç¤Þ¤«¤Ë¤¤¤Ã¤Æegrep¤ËÂåɽ¤µ¤ì¤ë¤â¤Î)¡¢¤ª¤è¤Ó¡¢´ðËÜRE¤â¤·¤¯¤ÏBRE(Âç¤Þ¤«¤Ë¤¤¤Ã¤Æed¤ËÂåɽ¤µ¤ì¤ë¤â¤Î)¤Ç¤¹¡£ PostgreSQL¤ÏξÊý¤Î·Á¼°¤ò¥µ¥Ý¡¼¥È¤·¡¢¤µ¤é¤Ë¡¢POSIXɸ½à¤Ë¤Ï¤Ê¤¤¤¬Perl¤äTcl¤Ê¤É¤Î¥×¥í¥°¥é¥ß¥ó¥°¸À¸ì¤ÇÍøÍѤǤ¤ë¤³¤È¤è¤ê¹¤¯»ÈÍѤµ¤ì¤ë¤è¤¦¤Ë¤Ê¤Ã¤¿¡¢¤¤¤¯¤Ä¤«¤Î³ÈÄ¥¤â¥µ¥Ý¡¼¥È¤·¤Æ¤¤¤Þ¤¹¡£ Ëܽñ¤Ç¤Ï¡¢ÈóPOSIX³ÈÄ¥¤ò»ÈÍѤ·¤¿RE¤òºÇ¿·RE¤â¤·¤¯¤ÏARE¤È¸Æ¤Ó¤Þ¤¹¡£ ARE¤ÏERE¤ÎÀµ³Î¤Ê¾å°Ì¥»¥Ã¥È¤Ç¤¹¤¬¡¢BRE¤È¤ÏÊ£¿ô¤ÎµË¡¾å¤ÎÈó¸ß´¹¤ÊÅÀ¤¬¤¢¤ê¤Þ¤¹(¹¹¤ËÈó¾ï¤Ë¿¤¯¤ÎÀ©¸Â¤¬¤µ¤ì¤Æ¤¤¤Þ¤¹)¡£ ¤Þ¤º¡¢ARE¤ÈERE·Á¼°¤Ë¤Ä¤¤¤ÆÀâÌÀ¤·¡¢¤½¤·¤Æ¡¢ARE¤Ë¤Î¤ßŬÍѤµ¤ì¤ëµ¡Ç½¤ÎÃí°Õ¤ò¡¢¤µ¤é¤ËBRE¤È¤Î°ã¤¤¤Ë¤Ä¤¤¤Æ¤òÀâÌÀ¤·¤Þ¤¹¡£
Ãí°Õ: PostgreSQL¤Ç¼õ¤±Æþ¤ì¤é¤ì¤ëÀµµ¬É½¸½¤Î·Á¼°¤Ïregex_flavor¼Â¹Ô»þ¥Ñ¥é¥á¡¼¥¿(¹à16.4¤ò»²¾È)¤ÎÀßÄê¤ÇÁªÂò¤¹¤ë¤³¤È¤¬¤Ç¤¤Þ¤¹¡£ Ä̾ï¤ÎÀßÄê¤Ïadvanced¤Ç¤¹¡£ ¤·¤«¤·¡¢extended¤òÁªÂò¤·¤Æ¡¢PostgreSQL¥ê¥ê¡¼¥¹7.4¤è¤êÁ°¤Î¥ê¥ê¡¼¥¹¤È¤Î¸åÊý¸ß´¹À¤òºÇÂç¤Ë¤¹¤ë¤³¤È¤â¤Ç¤¤Þ¤¹¡£
Àµµ¬É½¸½¤Ï|¤Ç¶èÀÚ¤é¤ì¤¿¡¢¤Ò¤È¤Ä¤Þ¤¿¤ÏÊ£¿ô¤Î¥Ö¥é¥ó¥Á¤È¤·¤ÆÄêµÁ¤µ¤ì¤Þ¤¹¡£ ¥Ö¥é¥ó¥Á¤Î°ì¤Ä¤È¤Ç¤â¥Þ¥Ã¥Á¤¹¤ì¤Ð¥Þ¥Ã¥Á¤·¤¿¤³¤È¤Ë¤Ê¤ê¤Þ¤¹¡£
¥Ö¥é¥ó¥Á¤Ï¥¼¥í¸Ä°Ê¾å¤Î½¤¾þ¥¢¥È¥à¤â¤·¤¯¤ÏÀ©Ìó¤ÎÏ¢·ë¤Ç¤¹¡£ ºÇ½é¤Î¤â¤Î¤Ë¥Þ¥Ã¥Á¤·¡¢¤½¤Î¼¡¤Ë¥Þ¥Ã¥Á¤·¡¢¤È¤¤¤¦¤Õ¤¦¤Ë¥Þ¥Ã¥Á¤µ¤ì¤Þ¤¹¡£ ¤Ê¤ª¡¢¶õ¤Î¥Ö¥é¥ó¥Á¤Ï¶õʸ»ú¤Ë¥Þ¥Ã¥Á¤·¤Þ¤¹¡£
½¤¾þ¥¢¥È¥à¤È¤Ï¡¢Ã±°ì¤Î½¤¾þ»Ò¤¬¸å¤í¤ËÉÕ¤¯²ÄǽÀ¤¬¤¢¤ë¥¢¥È¥à¤Î¤³¤È¤Ç¤¹¡£ ½¤¾þ»Ò¤¬¤Ê¤¤¤È¡¢¥¢¥È¥à¤Ë°ìÃפ¹¤ë¤â¤Î¤¬¥Þ¥Ã¥Á¤·¤¿¤³¤È¤Ë¤Ê¤ê¤Þ¤¹¡£ ½¤¾þ»Ò¤¬¤¢¤ë¾ì¹ç¡¢¥¢¥È¥à¤È¤Î°ìÃפ¬²¿²ó¤¢¤ë¤«¤Ç¥Þ¥Ã¥Á¤·¤¿¤³¤È¤Ë¤Ê¤ê¤Þ¤¹¡£ ¥¢¥È¥à¤Ï¡¢É½9-12¤Ë¼¨¤·¤¿¤â¤Î¤Î¤¤¤º¤ì¤«¤ò¤È¤ë¤³¤È¤¬¤Ç¤¤Þ¤¹¡£ ɽ9-13¤ËÀßÄê²Äǽ¤Ê½¤¾þ»Ò¤È¤½¤Î°ÕÌ£¤ò¼¨¤·¤Þ¤¹¡£
À©Ìó¤Ï¶õʸ»ú¤Ë¡¢ÆÃÄê¤Î¾ò·ï¤Ë¹ç¤¦¾ì¹ç¤Î¤ß¤Ë¥Þ¥Ã¥Á¤·¤Þ¤¹¡£ ¥¢¥È¥à¤¬»ÈÍѤǤ¤ë½ê¤ÇÀ©Ìó¤ò»ÈÍѤ¹¤ë¤³¤È¤¬¤Ç¤¤Þ¤¹¡£ ¤¿¤À¤·¡¢¤½¤Î¸å¤Ë½¤¾þ»Ò¤òÉÕ¤±¤ë¤³¤È¤Ï¤Ç¤¤Þ¤»¤ó¡£ ñ½ã¤ÊÀ©Ìó¤òɽ9-14¤Ë¼¨¤·¤Þ¤¹¡£ ¸å¤Ç¾¤Î¤¤¤¯¤Ä¤«¤ÎÀ©Ìó¤òÀâÌÀ¤·¤Þ¤¹¡£
ɽ 9-12. Àµµ¬É½¸½¤Î¥¢¥È¥à
| ¥¢¥È¥à | ÀâÌÀ |
|---|---|
| (re) | (¤³¤³¤Çre ¤ÏǤ°Õ¤ÎÀµµ¬É½¸½¤Ç¤¹¡£) re¤Ë¥Þ¥Ã¥Á¤¹¤ë¤â¤Î¤¬¥Þ¥Ã¥Á¤·¤Þ¤¹¡£¤Þ¤¿¡¢¤³¤Î¥Þ¥Ã¥Á¤ÏÊó¹ðÍѤÈÃí¼á¤¬ÉÕ¤±¤é¤ì¤Þ¤¹¡£ |
| (?:re) | ¾å¤ÈƱ¤¸¡£¤¿¤À¤·¡¢¤³¤Î¥Þ¥Ã¥Á¤ÏÊó¹ðÍѤÈÃí¼á¤¬ÉÕ¤±¤é¤ì¤Þ¤»¤ó¡£ ("¼è¤ê¹þ¤Þ¤ì¤Ê¤¤"³ç¸Ì¤Î½¸¹ç)(ARE¤Î¤ß) |
| . | Ǥ°Õ¤Î°ìʸ»ú¤Ë¥Þ¥Ã¥Á¤·¤Þ¤¹¡£ |
| [chars] | ¥Ö¥é¥±¥Ã¥È¼°¡£ chars¤Î¤¤¤º¤ì¤«°ì¤Ä¤Ë¥Þ¥Ã¥Á¤·¤Þ¤¹¡£ (¾ÜºÙ¤Ï¹à9.6.3.2¤ò»²¾È¤·¤Æ¤¯¤À¤µ¤¤¡£) |
| \k | (¤³¤³¤Çk¤Ï±Ñ¿ô»ú°Ê³°¤Ç¤¹¡£) ÉáÄ̤Îʸ»ú¤È¤·¤Æ»ØÄꤷ¤¿Ê¸»ú¤Ë¥Þ¥Ã¥Á¤·¤Þ¤¹¡£ Î㤨¤Ð¡¢\\¤Ï¥Ð¥Ã¥¯¥¹¥é¥Ã¥·¥åʸ»ú¤Ç¤¹¡£ |
| \c | ¤³¤³¤Çc¤Ï±Ñ¿ô»ú¤Ç¤¹¡£ (¤ª¤½¤é¤¯Â¾¤Îʸ»ú¤¬¸å¤Ë³¤¤Þ¤¹¡£) ¥¨¥¹¥±¡¼¥×¤Ç¤¹¡£ ¹à9.6.3.3¤ò»²¾È¤·¤Æ¤¯¤À¤µ¤¤¡£ (ARE¤Î¤ß¡¢ERE¤ÈBRE¤Ç¤Ï¤³¤ì¤Ïc¤Ë¥Þ¥Ã¥Á¤·¤Þ¤¹¡£) |
| { | ľ¸å¤Ë¿ô»ú°Ê³°¤¬¤¢¤ë¾ì¹ç¡¢º¸Ãæ³ç¸Ì{¤Ë¥Þ¥Ã¥Á¤·¤Þ¤¹¡£ ľ¸å¤Ë¿ô»ú¤¬Â³¤¯¾ì¹ç¡¢bound(¸å½Ò)¤Î»Ï¤Þ¤ê¤Ç¤¹¡£ |
| x | ¤³¤³¤Çx¤Ï¾¤Ë°ÕÌ£¤ò»ý¤¿¤Ê¤¤°ìʸ»ú¤Ç¤¹¡£ x¤Ë¥Þ¥Ã¥Á¤·¤Þ¤¹¡£ |
RE¤Ï\¤ò½ªÃ¼¤È¤¹¤ë¤³¤È¤Ï¤Ç¤¤Þ¤»¤ó¡£
Ãí°Õ: PostgreSQL¤Îʸ»úÎó¥ê¥Æ¥é¥ëÆâ¤Î¥Ð¥Ã¥¯¥¹¥é¥Ã¥·¥å(\)¤¬´û¤ËÆÃÊ̤ʰÕÌ£¤ò»ý¤Ã¤Æ¤¤¤ë¤³¤È¤ò˺¤ì¤Ê¤¤¤Ç¤¯¤À¤µ¤¤¡£ ¥Ð¥Ã¥¯¥¹¥é¥Ã¥·¥å¤ò´Þ¤à¥Ñ¥¿¡¼¥óÄê¿ô¤ò½ñ¤¯»þ¤Ë¤Ï¡¢¤½¤ÎʸÆâ¤Ç¤Ï2¤Ä¤Î¥Ð¥Ã¥¯¥¹¥é¥Ã¥·¥å¤ò½ñ¤«¤Ê¤±¤ì¤Ð¤Ê¤ê¤Þ¤»¤ó¡£
ɽ 9-13. Àµµ¬É½¸½½¤¾þ»Ò
| ½¤¾þ»Ò | ¥Þ¥Ã¥Á |
|---|---|
| * | ¥¢¥È¥à¤Î0¸Ä°Ê¾å¤ÎʤӤ˥ޥåÁ |
| + | ¥¢¥È¥à¤Î1¸Ä°Ê¾å¤ÎʤӤ˥ޥåÁ |
| ? | ¥¢¥È¥à¤Î0¸Ä¤Þ¤¿¤Ï1¸Ä¤ÎʤӤ˥ޥåÁ |
| {m} | ¥¢¥È¥à¤ÎÀµ³Î¤Ëm¸Ä¤ÎʤӤ˥ޥåÁ |
| {m,} | ¥¢¥È¥à¤Îm¸Ä°Ê¾å¤ÎʤӤ˥ޥåÁ |
| {m,n} | ¥¢¥È¥à¤Îm¸Ä°Ê¾ån°Ê²¼¤ÎʤӤ˥ޥåÁ¡£ m¤Ïn¤ò±Û¤¨¤ë¤³¤È¤Ï¤Ç¤¤Þ¤»¤ó¡£ |
| *? | *¤ÎÍßÄ¥¤é¤Ê¤¤¥Ð¡¼¥¸¥ç¥ó |
| +? | +¤ÎÍßÄ¥¤é¤Ê¤¤¥Ð¡¼¥¸¥ç¥ó |
| ?? | ?¤ÎÍßÄ¥¤é¤Ê¤¤¥Ð¡¼¥¸¥ç¥ó |
| {m}? | {m}¤ÎÍßÄ¥¤é¤Ê¤¤¥Ð¡¼¥¸¥ç¥ó |
| {m,}? | {m,}¤ÎÍßÄ¥¤é¤Ê¤¤¥Ð¡¼¥¸¥ç¥ó |
| {m,n}? | {m,n}¤ÎÍßÄ¥¤é¤Ê¤¤¥Ð¡¼¥¸¥ç¥ó |
{...}¤ò»ÈÍѤ¹¤ë·Á¼°¤Ï¥Ð¥¦¥ó¥É¤È¸Æ¤Ð¤ì¤Þ¤¹¡£ ¥Ð¥¦¥ó¥ÉÆâ¤Îm¤Èn¤È¤¤¤¦¿ô¤Ï¤ÏÉä¹æ̵¤·10¿ÊÀ°¿ô¤Ç¤¢¤ê¡¢0°Ê¾å255°Ê²¼¤ÎÃͤò¤È¤ë¤³¤È¤¬¤Ç¤¤Þ¤¹¡£
ÍßÄ¥¤é¤Ê¤¤½¤¾þ»Ò(ARE¤Î¤ß¤Ç»ÈÍѲÄǽ)¤Ï¡¢ Âбþ¤¹¤ëÄ̾ï¤Î(ÍßÄ¥¤ê¤Î)¤â¤Î¤ÈƱ¤¸¤â¤Î¤Ë¥Þ¥Ã¥Á¤·¤Þ¤¹¤¬¡¢ºÇĹ¤Î¥Þ¥Ã¥Á¤Ç¤Ï¤Ê¤¯ºÇ¾¯¤Î¥Þ¥Ã¥Á¤ò¤È¤ê¤Þ¤¹¡£ ¾ÜºÙ¤Ï¹à9.6.3.5¤ò»²¾È¤·¤Æ¤¯¤À¤µ¤¤¡£
Ãí°Õ: ½¤¾þ»Ò¤Îľ¸å¤Ë½¤¾þ»Ò¤ò³¤±¤ë¤³¤È¤Ï¤Ç¤¤Þ¤»¤ó¡£ ½¤¾þ»Ò¤«¤é¼°¤äÉû¼°¤ò»Ï¤á¤ë¤³¤È¤Ï¤Ç¤¤º¡¢¤Þ¤¿¡¢^¤ä|¤Îľ¸å¤ËÉÕ¤±¤ë¤³¤È¤â¤Ç¤¤Þ¤»¤ó¡£
ɽ 9-14. Àµµ¬É½¸½À©Ìó
| À©Ìó | ÀâÌÀ |
|---|---|
| ^ | ʸ»úÎó¤ÎÀèƬ¤Ë¥Þ¥Ã¥Á |
| $ | ʸ»úÎó¤ÎËöÈø¤Ë¥Þ¥Ã¥Á |
| (?=re) | Àè¹Ô¹ÎÄ긡º÷¤Ï¡¢re¤Ë¥Þ¥Ã¥Á¤¹¤ëÉôʬʸ»úÎ󤫤é»Ï¤Þ¤ëǤ°Õ¤Î¾ì½ê¤Ë¥Þ¥Ã¥Á¤·¤Þ¤¹¡£ |
| (?!re) | Àè¹ÔÈÝÄ긡º÷¤Ï¡¢re¤Ë¥Þ¥Ã¥Á¤·¤Ê¤¤Éôʬʸ»úÎ󤫤é»Ï¤Þ¤ëǤ°Õ¤Î¾ì½ê¤Ë¥Þ¥Ã¥Á¤·¤Þ¤¹¡£ |
Àè¹Ô¸¡º÷À©Ìó¤Ë¤Ï¸åÊý»²¾È(¹à9.6.3.3»²¾È)¤ò´Þ¤á¤ë¤³¤È¤Ï¤Ç¤¤Þ¤»¤ó¡£ ¤Þ¤¿¡¢¤½¤ÎÃæ¤Î³ç¸Ì¤Ï¤¹¤Ù¤Æ¼è¤ê¹þ¤à¤â¤Î¤Ç¤Ï¤Ê¤¤¤È¤ß¤Ê¤µ¤ì¤Þ¤¹¡£
¥Ö¥é¥±¥Ã¥È¼°¤È¤Ï¡¢[]Æâ¤Îʸ»ú¤Î¥ê¥¹¥È¤Ç¤¹¡£ Ä̾盧¤ì¤Ï¤½¤Î¥ê¥¹¥ÈÆâ¤ÎǤ°Õ¤Î°ìʸ»ú¤Ë¥Þ¥Ã¥Á¤·¤Þ¤¹¡£(¤·¤«¤·¡¢°Ê¹ß¤ò»²¾È¤·¤Æ¤¯¤À¤µ¤¤¡£) ¥ê¥¹¥È¤¬^¤«¤é»Ï¤Þ¤ë¾ì¹ç¡¢¤½¤Î¥ê¥¹¥È¤Î»Ä¤ê¤Ë¤Ï̵¤¤Ç¤°Õ¤Î°ìʸ»ú¤Ë¥Þ¥Ã¥Á¤·¤Þ¤¹¡£ ¥ê¥¹¥ÈÆâ¤Î2ʸ»ú¤¬-¤Ç¶èÀÚ¤é¤ì¤Æ¤¤¤¿¾ì¹ç¡¢¤³¤ì¤Ï2¤Ä(¤ò´Þ¤à)¤Î´Ö¤Ë¤¢¤ëʸ»úÈÏ°ÏÁ´ÂΤòɽ¤¹¾Êά·Á¤È¤Ê¤ê¤Þ¤¹¡£ Î㤨¤Ð¡¢ASCII¤Ë¤ª¤±¤ë[0-9]¤Ï¤¹¤Ù¤Æ¤Î¿ô»ú¤Ë¥Þ¥Ã¥Á¤·¤Þ¤¹¡£ Î㤨¤Ða-c-e¤È¤¤¤Ã¤¿¡¢½ªÃ¼¤ò¶¦Í¤¹¤ë2¤Ä¤ÎÈϰϤÏÉÔÀµ¤Ç¤¹¡£ ÈϰϤÏʤӤξȹç½ç¤ËÈó¾ï¤Ë°Í¸¤·¤Æ¤¤¤Þ¤¹¡£ ¤Ç¤¹¤Î¤Ç¡¢°Ü¿¢Í½Äê¤Î¥×¥í¥°¥é¥à¤Ç¤Ï¤³¤ì¤Ë°Í¸¤·¤Æ¤Ï¤Ê¤ê¤Þ¤»¤ó¡£
¤³¤Î¥ê¥¹¥È¤Ë]¤½¤Î¤â¤Î¤ò´Þ¤á¤ë¤Ë¤Ï¡¢¤½¤ì¤òÀèƬʸ»ú(¤â¤·¤¢¤ì¤Ð^¤Î¸å¤Îʸ»ú)¤Ë¤·¤Æ¤¯¤À¤µ¤¤¡£ -¤½¤Î¤â¤Î¤ò´Þ¤á¤ë¤Ë¤Ï¡¢¤½¤ì¤òÀèƬ¤â¤·¤¯¤ÏËöÈø¤Îʸ»ú¤È¤¹¤ë¤«¡¢ÈϰϤÎ2ÈÖÌܤνªÃ¼¤È¤·¤Æ¤¯¤À¤µ¤¤¡£ -¤òÈϰϤÎ1ÈÖÌܤνªÃ¼¤Ç»ÈÍѤ¹¤ë¤Ë¤Ï¡¢[.¤È.]¤Ç¤½¤ì¤ò°Ï¤ß¡¢¾È¹çÍ×ÁÇ(¸å½Ò)¤Ë¤·¤Æ¤¯¤À¤µ¤¤¡£ ¤³¤ì¤é¤Îʸ»ú¤Ë¤ÏÎã³°¤¬¤¢¤ê¡¢[(¼¡ÃÊÍî¤ò»²¾È)¡¢¥¨¥¹¥±¡¼¥×(ARE¤Î¤ß)¡¢Â¾¤Î¤¹¤Ù¤Æ¤ÎÆüìʸ»ú¤ÎÁȹ礻¤Ï¥Ö¥é¥±¥Ã¥È¼°Æâ¤Ç¤ÏÆüì¤Ê°ÕÌ£¤ò»ý¤Á¤Þ¤»¤ó¡£ Æäˡ¢\¤ÏERE¤ÈBREµ¬Â§¤Ë½¾¤¦¾ì¹ç¤ÏÆÃÊ̤Ǥʤ¯¤Ê¤ê¤Þ¤¹¡£ ¤·¤«¤·¡¢ARE¤Ç¤Ï(¥¨¥¹¥±¡¼¥×¤Î»Ï¤Þ¤ê¤È¤·¤Æ)ÆÃÊ̤ʰÕÌ£¤ò»ý¤Á¤Þ¤¹¡£
¥Ö¥é¥±¥Ã¥È¼°Æâ¤Ë¡¢¾È¹çÍ×ÁÇ(ʸ»ú¡¢Ã±°ìʸ»ú¤Ç¤¢¤ë¤«¤Î¤è¤¦¤Ë¾È¹ç¤¹¤ëÊ£¿ôʸ»ú¤Îʤӡ¢¤â¤·¤¯¤Ï¤½¤ì¤¾¤ì¤Î¾È¹çʤӤÎ̾Á°)¤¬[.¤È.]¤Î´Ö¤Ë¤¢¤ë¤È¡¢¤½¤Î¾È¹çÍ×ÁǤÎʸ»ú¤ÎʤӤò°ÕÌ£¤·¤Þ¤¹¡£ ¤³¤ÎʤӤϥ֥饱¥Ã¥È¼°¤Î¥ê¥¹¥È¤Î°ìÍ×ÁǤǤ¹¡£ ¤³¤¦¤·¤Æ¡¢Í×ÁǤò¾È¹ç¤¹¤ëÊ£¿ôʸ»ú¤ò´Þ¤à¥Ö¥é¥±¥Ã¥È¼°¤Ï1ʸ»ú°Ê¾å¤Ë¥Þ¥Ã¥Á¤¹¤ë¤³¤È¤¬¤Ç¤¤Þ¤¹¡£ Î㤨¤Ð¡¢¾È¹çʤӤ¬ch¾È¹çÍ×ÁǤò´Þ¤à¾ì¹ç¡¢Àµµ¬É½¸½[[.ch.]]*c¤Ïchchcc¤È¤¤¤¦Ê¸»ú¤ÎºÇ½é¤Î5ʸ»ú¤Ë¥Þ¥Ã¥Á¤·¤Þ¤¹¡£
Ãí°Õ: º£¤Î½ê¡¢PostgreSQL¤ÏÊ£¿ôʸ»ú¾È¹çÍ×ÁǤò»ý¤Á¤Þ¤»¤ó¡£ ¤³¤Î¾ðÊó¤Ï¾Íè¤Î¿¶Éñ¤¤¤Î²ÄǽÀ¤òÀâÌÀ¤·¤¿¤â¤Î¤Ç¤¹¡£
¥Ö¥é¥±¥Ã¥È¼°Æâ¤Î[=¤È=]¤Î´Ö¤Ë¾È¹çÍ×ÁǤÏƱÃÍ¥¯¥é¥¹¤Ç¤¹¡£ ¤¹¤Ù¤Æ¤Î¾È¹çÍ×ÁǤÎʸ»ú¤ÎʤӤ¬¼«¿È¤ò´Þ¤à¤â¤Î¤ÈÅù²Á¤Ç¤¢¤ë¤³¤È¤ò¼¨¤·¤Þ¤¹¡£ (¾¤ËÅù²Á¤Ê¾È¹çÍ×ÁǤ¬¤¢¤ë¾ì¹ç¡¢[.¤È.]¤Ç°Ï¤Þ¤ì¤¿¤«¤Î¤è¤¦¤Ë°·¤ï¤ì¤Þ¤¹¡£) Î㤨¤Ð¡¢[[=o=]]¡¢[[=^=]]¤ª¤è¤Ó[o^]¤¬¤¹¤Ù¤ÆƱ°Õ¸ì¤Ç¤¢¤ì¤Ð¡¢o¤È^¤ÏƱÃÍ¥¯¥é¥¹¤Î¥á¥ó¥Ð¤Ç¤¹¡£ ƱÃÍ¥¯¥é¥¹¤ÏÈϰϤνªÃ¼¤Ë¤Ï¤Ê¤ê¤Þ¤»¤ó¡£
¥Ö¥é¥±¥Ã¥È¼°Æâ¤Ç¤Ï¡¢[:¤È:]¤Î´Ö¤Ë¤¢¤ëʸ»ú¥¯¥é¥¹¤Î̾¾Î¤Ï¡¢¤½¤Î¥¯¥é¥¹¤Ë°¤¹¤ë¤¹¤Ù¤Æ¤Îʸ»ú¤Î¥ê¥¹¥È¤ò°ÕÌ£¤·¤Þ¤¹¡£ ɸ½àʸ»ú¥¯¥é¥¹Ì¾¤Ï¡¢alnum¡¢alpha¡¢blank¡¢cntrl¡¢digit¡¢graph¡¢lower¡¢print¡¢punct¡¢space¡¢upper¡¢xdigit¤Ç¤¹¡£ ¤³¤ì¤é¤Ïctype¤ÇÄêµÁ¤µ¤ì¤¿Ê¸»ú¥¯¥é¥¹¤ò°ÕÌ£¤·¤Þ¤¹¡£ ¥í¥±¡¼¥ë¤ÏÊ̤Τâ¤Î¤òÄ󶡤¹¤ë²ÄǽÀ¤¬¤¢¤ê¤Þ¤¹¡£ ʸ»ú¥¯¥é¥¹¤ÏÈϰϤνªÃ¼¤Ç¤Ï»ÈÍѤ¹¤ë¤³¤È¤¬¤Ç¤¤Þ¤»¤ó¡£
¥Ö¥é¥±¥Ã¥È¼°¤Ë¤Ï2¤Ä¤ÎÆüì¤Ê¾ì¹ç¤¬¤¢¤ê¤Þ¤¹¡£ [[:<:]]¤È[[:>:]]¤È¤¤¤¦¥Ö¥é¥±¥Ã¥È¼°¤Ï¡¢ÀèƬ¤È½ªÃ¼¤Îñ¸ì¤¬¤½¤ì¤¾¤ì¶õʸ»ú¤Ç¤¢¤ë¤³¤È¤Ë¥Þ¥Ã¥Á¤¹¤ëÀ©Ìó¤Ç¤¹¡£ ñ¸ì¤Ï¡¢Ã±¸ìʸ»ú¤¬Á°¸å¤ËÉÕ¤«¤Ê¤¤Ã±¸ìʸ»ú¤ÎʤӤȤ·¤ÆÄêµÁ¤µ¤ì¤Þ¤¹¡£ ñ¸ìʸ»ú¤È¤Ï1¤Ä¤Îalnumʸ»ú¤Ç¤¹¡£ (ctype¤ÇÄêµÁ¤µ¤ì¤Æ¤¤¤Þ¤¹¡£) ¤³¤ì¤Ï¡¢POSIX 1003.2¤È¤Î¸ß´¹À¤Ï¤¢¤ê¤Þ¤¹¤¬¡¢¤½¤³¤Ç¤ÏÄêµÁ¤µ¤ì¤Æ¤¤¤Ê¤¤¼°¤Ç¤¹¡£ ¤Ç¤¹¤Î¤Ç¡¢Â¾¥·¥¹¥Æ¥à¤Ø°Ü¿¢Í½Äê¤Î¥½¥Õ¥È¥¦¥§¥¢¤Ç¤Î»ÈÍѤˤÏÃí°Õ¤¬É¬ÍפǤ¹¡£ Ä̾ï¸å½Ò¤ÎÀ©Ì󥨥¹¥±¡¼¥×¤ÎÊý¤¬Îɤ¯»È¤ï¤ì¤Þ¤¹¡£ (¤³¤ì¤âɸ½à¤Ç¤Ï¤¢¤ê¤Þ¤»¤ó¤¬¡¢ÆþÎϤ·¤ä¤¹¤¯¤Ê¤Ã¤Æ¤¤¤Þ¤¹¡£)
¥¨¥¹¥±¡¼¥×¤È¤Ï¡¢\¤«¤é»Ï¤Þ¤ê±Ñ¿ô»ú¤¬¤½¤Î¸å¤Ë³¤¯Æüì¤ÊʤӤǤ¹¡£ ¥¨¥¹¥±¡¼¥×¤Ë¤Ï¡¢Ê¸»ú¥¨¥ó¥È¥ê¡¢¥¯¥é¥¹¾Êά¡¢À©Ì󥨥¹¥±¡¼¥×¡¢¸åÊý»²¾È¤È¤¤¤Ã¤¿ÍÍ¡¹¤ÊÊѼ郎¤¢¤ê¤Þ¤¹¡£ \¤Î¸å¤Ë±Ñ¿ô»ú¤¬Â³¤¯¤¬¡¢Í¸ú¤Ê¥¨¥¹¥±¡¼¥×¤ò¹½À®¤·¤Ê¤¤Ê¤ӤÏARE¤Ç¤ÏÉÔÀµ¤Ç¤¹¡£ ERE¤Ë¤Ï¥¨¥¹¥±¡¼¥×¤Ï¤¢¤ê¤Þ¤»¤ó¡£ ¥Ö¥é¥±¥Ã¥È¼°¤Î³°Â¦¤Ç¤Ï¡¢\¤Î¸å¤Ë±Ñ¿ô»ú¤¬Â³¤¯Ê¤ӤÏñ¤ËÉáÄ̤Îʸ»ú¤È¤·¤Æ¤½¤Îʸ»ú¤ò°ÕÌ£¤·¤Þ¤¹¡£ ¥Ö¥é¥±¥Ã¥È¼°¤ÎÆ⦤Ǥϡ¢\¤ÏÉáÄ̤Îʸ»ú¤Ç¤¹¡£ (¤³¤Îʸ»ú¤ÏERE¤ÈARE´Ö¤ÎÈó¸ß´¹À¤Î1¤Ä¤Ç¤¹¡£)
ʸ»ú¥¨¥ó¥È¥ê¥¨¥¹¥±¡¼¥×¤ÏÈó°õ»úʸ»ú¤äREÆâ¤ÇÉÔÊؤÊʸ»ú¤Î»ØÄê¤ò´Êά²½¤¹¤ë¤¿¤á¤Ë¸ºß¤·¤Þ¤¹¡£ ¤³¤ì¤é¤òɽ9-15¤Ë¼¨¤·¤Þ¤¹¡£
¥¯¥é¥¹¾Êά¥¨¥¹¥±¡¼¥×¤Ï¡¢¤¢¤ë¤è¤¯»ÈÍѤµ¤ì¤ëʸ»ú¥¯¥é¥¹¤Î¾Êά·Á¤òÄ󶡤·¤Þ¤¹¡£ ¤³¤ì¤é¤òɽ9-16¤Ë¼¨¤·¤Þ¤¹¡£
À©Ì󥨥¹¥±¡¼¥×¤Ï¡¢»ØÄꤷ¤¿¾ò·ï¤Ë¹ç¤¦¾ì¹ç¤Ë¶õʸ»ú¤Ë¥Þ¥Ã¥Á¤¹¤ëÀ©Ìó¤ò¥¨¥¹¥±¡¼¥×¤È¤·¤Æɽ¤·¤¿¤â¤Î¤Ç¤¹¡£ ¤³¤ì¤é¤òɽ9-17¤Ë¼¨¤·¤Þ¤¹¡£
¸åÊý»²¾È(\n)¤Ï¡¢Ä¾Á°¤Ë³ç¸Ì¤Ç°Ï¤Þ¤ì¤¿Éû¼°¤Ë¤è¤Ã¤Æ¥Þ¥Ã¥Á¤µ¤ì¤¿¡¢nÈÖÌܤÎƱ°ìʸ»úÎó¤Ë¥Þ¥Ã¥Á¤·¤Þ¤¹¡£ (ɽ9-18¤ò»²¾È¤·¤Æ¤¯¤À¤µ¤¤¡£) Î㤨¤Ð¡¢([bc])\1¤Ïbb¤â¤·¤¯¤Ïcc¤Ë¥Þ¥Ã¥Á¤·¤Þ¤¹¤¬¡¢bc¤äcb¤Ë¤Ï¥Þ¥Ã¥Á¤·¤Þ¤»¤ó¡£ RE¤Ç¤ÏÉû¼°Á´ÂΤϸåÊý»²¾È¤ÎÁ°¤Ë¤Ê¤±¤ì¤Ð¤Ê¤ê¤Þ¤»¤ó¡£ Éû¼°¤Ï³«³ç¸Ì¤Î½çÈÖ¤ÇÈÖ¹æÉÕ¤±¤µ¤ì¤Þ¤¹¡£ ¼è¤ê¹þ¤Þ¤Ê¤¤³ç¸Ì¤ÏÉû¼°¤òÄêµÁ¤·¤Þ¤»¤ó¡£
Ãí°Õ: ¥¨¥¹¥±¡¼¥×¤ÎÀèƬ¤Î\¤òSQLʸ»úÄê¿ô¤È¤·¤Æ¥Ñ¥¿¡¼¥ó¤ËÆþÎϤ¹¤ë»þ¤Ë¤ÏÆó½Å¤Ë¤·¤Ê¤±¤ì¤Ð¤Ê¤é¤Ê¤¤¤³¤È¤ò˺¤ì¤Ê¤¤¤Ç¤¯¤À¤µ¤¤¡£
ɽ 9-15. Àµµ¬É½¸½Ê¸»ú¥¨¥ó¥È¥ê¥¨¥¹¥±¡¼¥×
| ¥¨¥¹¥±¡¼¥× | ÀâÌÀ |
|---|---|
| \a | ·ÙÊó(¥Ù¥ë)ʸ»ú¡£C¸À¸ì¤ÈƱ¤¸ |
| \b | ¥Ð¥Ã¥¯¥¹¥Ú¡¼¥¹¡£C¸À¸ì¤ÈƱ¤¸ |
| \B | ¥Ð¥Ã¥¯¥¹¥é¥Ã¥·¥å¤ÎɬÍפÊÆó½Å²½²ó¿ô¤ò¸º¤é¤¹¤¿¤á¤Î\¤ÎƱµÁ¸ì |
| \cX | (¤³¤³¤ÇX¤ÏǤ°Õ¤Îʸ»ú¤Ç¤¹¡£) ¤½¤Î²¼°Ì5¥Ó¥Ã¥È¤¬X¤ÈƱ°ì¡¢¤½¤Î¾¤Î¥Ó¥Ã¥È¤¬0¤È¤Ê¤ëʸ»ú |
| \e | ¾È¹ç½ç̾¤¬ESC¤È¤Ê¤ëʸ»ú¡¢¤½¤ì¤Ë¼ºÇÔ¤·¤¿¤é¡¢033¤È¤¤¤¦8¿Ê¿ôÃͤò»ý¤Äʸ»ú¡£ |
| \f | ²þ¥Ú¡¼¥¸¡¢C¸À¸ì¤ÈƱ¤¸ |
| \n | ²þ¹Ô¡¢C¸À¸ì¤ÈƱ¤¸ |
| \r | Éüµ¢¡¢C¸À¸ì¤ÈƱ¤¸ |
| \t | ¿åÊ¿¥¿¥Ö¡¢C¸À¸ì¤ÈƱ¤¸ |
| \uwxyz | (¤³¤³¤Çwxyz¤ÏÀµ³Î¤Ë4·å¤Î16¿Ê¿ô¤Ç¤¹¡£) »ÈÍÑ¥Þ¥·¥ó¤Î¥Ð¥¤¥È½ç¤Çɽ¤·¤¿¡¢U+wxyz¤È¤¤¤¦Unicodeʸ»ú |
| \Ustuvwxyz | (¤³¤³¤Çstuvwxyz¤ÏÀµ³Î¤Ë8·å¤Î16¿Ê¿ô¤Ç¤¹¡£) ²¿¤é¤«¤Î²¾Äê¤Î¤¿¤á¤Ë³ÎÊݤµ¤ì¤¿Unicode³ÈÄ¥¡¢32¥Ó¥Ã¥È |
| \v | ¿âľ¥¿¥Ö¡¢C¸À¸ì¤ÈƱ¤¸ |
| \xhhh | (¤³¤³¤Çhhh¤ÏǤ°Õ¤Î16¿Ê¿ô¤ÎʤӤǤ¹¡£) ¤½¤Îʸ»ú¤Î16¿Ê¿ôÃͤ¬0xhhh¤È¤Ê¤ëʸ»ú¡£ (»ÈÍѤµ¤ì¤ë16¿Ê¿ô¤Î·å¿ô¤Ë´Ø¤ï¤é¤ºÃ±°ì¤Îʸ»ú¡£) |
| \0 | ¤½¤ÎÃͤ¬0¤È¤Ê¤ëʸ»ú |
| \xy | (¤³¤³¤Çxy¤ÏÀµ³Î¤Ë2·å¤Î8¿Ê¿ô¤Ç¡¢¸åÊý»²¾È¤Ç¤Ï¤¢¤ê¤Þ¤»¤ó¡£) ¤½¤ÎÃͤ¬0xy¤È¤Ê¤ëʸ»ú |
| \xyz | (¤³¤³¤Çxyz¤ÏÀµ³Î¤Ë3·å¤Î8¿Ê¿ô¤Ç¡¢¸åÊý»²¾È¤Ç¤Ï¤¢¤ê¤Þ¤»¤ó¡£) ¤½¤ÎÃͤ¬0xyz¤È¤Ê¤ëʸ»ú |
16¿Ê¿ô¤Î·å¤È¤Ï0-9¡¢a-f¡¢A-F¤Ç¤¹¡£ 8¿Ê¿ô¤Î·å¤È¤Ï0-7¤Ç¤¹¡£
¤³¤Îʸ»ú¥¨¥ó¥È¥ê¥¨¥¹¥±¡¼¥×¤Ï¾ï¤ËÉáÄ̤Îʸ»ú¤È²ò¼á¤µ¤ì¤Þ¤¹¡£ Î㤨¤Ð¡¢\135¤ÏASCII¤Î]¤È¤Ê¤ê¡¢\135¤Ï¥Ö¥é¥±¥Ã¥È¼°¤Î½ªÃ¼¤Ë¤Ï¤Ê¤ê¤Þ¤»¤ó¡£
ɽ 9-16. Àµµ¬É½¸½¥¯¥é¥¹¾Êά¥¨¥¹¥±¡¼¥×
| ¥¨¥¹¥±¡¼¥× | ÀâÌÀ |
|---|---|
| \d | [[:digit:]] |
| \s | [[:space:]] |
| \w | [[:alnum:]_] (note underscore is included) |
| \D | [^[:digit:]] |
| \S | [^[:space:]] |
| \W | [^[:alnum:]_] (¥¢¥ó¥À¡¼¥¹¥³¥¢¤¬´Þ¤Þ¤ì¤ë¤³¤È¤ËÃí°Õ) |
¥Ö¥é¥±¥Ã¥È¼°Æâ¤Ç¤Ï¡¢ \d¡¢\s¡¢¤ª¤è¤Ó\w¤Ï¤½¤Î³°Â¦¤ÎÂç³ç¸Ì¤ò¸«¼º¤¤¡¢\D¡¢\S¤ª¤è¤Ó\W¤ÏÉÔÀµ¤Ç¤¹¡£ (¤Ç¤¹¤«¤é¡¢Î㤨¤Ð[a-c\d]¤Ï[a-c[:digit:]]¤ÈƱ¤¸¤Ë¤Ê¤ê¤Þ¤¹¡£ ¤Þ¤¿¡¢[a-c\D]¤Ï[a-c^[:digit:]]¤ÈƱ¤¸¤Ë¤Ê¤ê¡¢ÉÔÀµ¤Ç¤¹¡£)
ɽ 9-17. Àµµ¬É½¸½À©Ì󥨥¹¥±¡¼¥×
| ¥¨¥¹¥±¡¼¥× | ÀâÌÀ |
|---|---|
| \A | ʸ»úÎó¤ÎÀèƬ¤Ë¤Î¤ß¥Þ¥Ã¥Á¤·¤Þ¤¹¡£ (^¤È¤Î°ã¤¤¤Ë¤Ä¤¤¤Æ¤Ï¹à9.6.3.5¤ò»²¾È¤·¤Æ¤¯¤À¤µ¤¤¡£) |
| \m | ñ¸ì¤ÎÀèƬ¤Ë¤Î¤ß¥Þ¥Ã¥Á¤·¤Þ¤¹¡£ |
| \M | ñ¸ì¤ÎËöÈø¤Ë¤Î¤ß¥Þ¥Ã¥Á¤·¤Þ¤¹¡£ |
| \y | ñ¸ì¤ÎÀèƬ¤â¤·¤¯¤ÏËöÈø¤Ë¤Î¤ß¥Þ¥Ã¥Á¤·¤Þ¤¹¡£ |
| \Y | ñ¸ì¤ÎÀèƬ¤â¤·¤¯¤ÏËöÈø°Ê³°¤Î¾ì½ê¤Ë¤Î¤ß¥Þ¥Ã¥Á¤·¤Þ¤¹¡£ |
| \Z | ʸ»úÎó¤ÎËöÈø¤Ë¤Î¤ß¥Þ¥Ã¥Á¤·¤Þ¤¹¡£ ($¤È¤Î°ã¤¤¤Ë¤Ä¤¤¤Æ¤Ï¹à9.6.3.5¤ò»²¾È¤·¤Æ¤¯¤À¤µ¤¤¡£) |
ñ¸ì¤ÏÁ°½Ò¤Î[[:<:]]¤È[[:>:]]¤Îµ¬Äê¤È¤ª¤ê¤ËÄêµÁ¤µ¤ì¤Þ¤¹¡£ ¥Ö¥é¥±¥Ã¥È¼°Æâ¤Ç¤ÏÀ©Ì󥨥¹¥±¡¼¥×¤ÏÉÔÀµ¤Ç¤¹¡£
ɽ 9-18. Àµµ¬É½¸½¸åÊý»²¾È
| ¥¨¥¹¥±¡¼¥× | ÀâÌÀ |
|---|---|
| \m | (¤³¤³¤Çm¤ÏÈó¥¼¥í¤Î¿ô¤Ç¤¹¡£) Éû¼°¤ÎmÈÖÌܤؤθåÊý»²¾È |
| \mnn | (¤³¤³¤Çm¤ÏÈó¥¼¥í¤Î¿ô¤Ç¤¹¡£ nn¤Ç¹¹¤Ë·å¤ò»ØÄꤷ¤Þ¤¹¡£ mnn10¿Ê¿ôÃͤϼè¤ê¹þ¤ß³ç¸Ì¤Î¿ô¤è¤ê¤â¿¤¯¤Æ¤Ï¤Ê¤ê¤Þ¤»¤ó¡£) Éû¼°¤ÎmnnÈÖÌܤؤθåÊý»²¾È |
Ãí°Õ: 8¿Ê¿ô¤Îʸ»ú¥¨¥ó¥È¥ê¥¨¥¹¥±¡¼¥×¤È¸åÊý»²¾È¤Î´Ö¤Ë¤ÏÎò»ËŪ¤ÊÛ£ËæÀ¤¬¤¢¤ê¤Þ¤¹¡£ ¾å¤Ç¥Ò¥ó¥È¤·¤Æ¼¨¤·¤¿¤è¤¦¤Ë¤³¤ì¤Ïȯ¸«Åª¼êË¡¤Ç²ò·è¤µ¤ì¤Þ¤¹¡£ ÀèƬ¤Î0¤Ï¾ï¤Ë8¿Ê¿ô¥¨¥¹¥±¡¼¥×¤ò¼¨¤·¤Þ¤¹¡£ ¤½¤Î¸å¤Ë¿ô»ú¤¬Â³¤«¤Ê¤¤Ã±°ì¤ÎÈó¥¼¥í¿ô»ú¤Ï¾ï¤Ë¸åÊý»²¾È¤È¤·¤Æ²ò¼á¤µ¤ì¤Þ¤¹¡£ ¥¼¥í¤«¤é»Ï¤Þ¤é¤Ê¤¤Ê£¿ô¿ô»ú¤ÎʤӤϡ¢Å¬ÀÚ¤ÊÉû¼°¤Î¸å¤Ë¤¢¤ì¤Ð(¤Ä¤Þ¤ê¡¢¤½¤ÎÈֹ椬¸åÊý»²¾ÈÍѤÎÈÏ°ÏÆâ¤Ë¤¢¤ì¤Ð)¸åÊý»²¾È¤È¤·¤Æ²ò¼á¤µ¤ì¤Þ¤¹¡£ ¤µ¤â¤Ê¤¯¤Ð¡¢8¿Ê¿ô¤È¤·¤Æ²ò¼á¤µ¤ì¤Þ¤¹¡£
¾å½Ò¤Î¼ç¹½Ê¸¤Î¾¤Ë¡¢Æüì¤Ê·Á¼°¤ä»¨Â¿¤Ê¹½Ê¸Åª¤Êµ¡Ç½¤¬»ÈÍѲÄǽ¤Ç¤¹¡£
Ä̾»ÈÍѤµ¤ì¤ëRE¤Î¼ïÎà¤Ïregex_flavor¤Ç·èÄꤵ¤ì¤Þ¤¹¡£ ¤·¤«¤·¡¢·èÄê»ÒÁ°ÃÖ»ì¤Ë¤è¤Ã¤Æ¾å½ñ¤¤¹¤ë¤³¤È¤¬¤Ç¤¤Þ¤¹¡£ RE¤¬***:¤«¤é»Ï¤Þ¤ë¼ïÎà¤Î¤â¤Î¤Ç¤¢¤ì¤Ð¡¢RE¤Î»Ä¤ê¤ÏARE¤È²ò¼á¤µ¤ì¤Þ¤¹¡£ RE¤¬***=¤«¤é»Ï¤Þ¤ë¼ïÎà¤Î¤â¤Î¤Ç¤¢¤ì¤Ð¡¢RE¤Î»Ä¤ê¤Ï¡¢¤¹¤Ù¤Æ¤Îʸ»ú¤òÉáÄ̤Îʸ»ú¤È¤ß¤Ê¤·¤¿¥ê¥Æ¥é¥ëʸ»úÎó¤È²ò¼á¤µ¤ì¤Þ¤¹¡£
ARE¤ÏËä¤á¹þ¤ß¥ª¥×¥·¥ç¥ó¤«¤é»Ï¤á¤ë¤³¤È¤â¤Ç¤¤Þ¤¹¡£ (?xyz)¤È¤¤¤¦Ê¤ӤǻĤê¤ÎRE¤Ë±Æ¶Á¤¹¤ë¥ª¥×¥·¥ç¥ó¤ò»ØÄꤷ¤Þ¤¹¡£ (¤³¤³¤Çxyz¤Ï1¤Ä°Ê¾å¤Î±Ñ»ú¤Ç¤¹¡£) ¤³¤Î¥ª¥×¥·¥ç¥ó¤Ï¡¢»öÁ°¤Ë·èÄꤵ¤ì¤¿(RE¼ïÎà¤äÂçʸ»ú¾®Ê¸»ú¤Î¶èÊ̤ò´Þ¤à)¥ª¥×¥·¥ç¥ó¤ò¾å½ñ¤¤·¤Þ¤¹¡£ »ÈÍѲÄǽ¤Ê¥ª¥×¥·¥ç¥óʸ»ú¤òɽ9-19¤Ë¼¨¤·¤Þ¤¹¡£
ɽ 9-19. AREËä¤á¹þ¤ß¥ª¥×¥·¥ç¥óʸ»ú
| ¥ª¥×¥·¥ç¥ó | ÀâÌÀ |
|---|---|
| b | »Ä¤ê¤ÎRE¤ÏBRE |
| c | Âçʸ»ú¾®Ê¸»ú¤ò¶èÊ̤¹¤ë¥Þ¥Ã¥Á(±é»»»Ò¼ïÎà¤ò¾å½ñ¤¤·¤Þ¤¹¡£) |
| e | »Ä¤ê¤ÎRE¤ÏERE |
| i | Âçʸ»ú¾®Ê¸»ú¤ò¶èÊ̤·¤Ê¤¤¥Þ¥Ã¥Á(¹à9.6.3.5¤ò»²¾È)(±é»»»Ò¼ïÎà¤ò¾å½ñ¤¤·¤Þ¤¹¡£) |
| m | n¤ÎÎò»ËŪ¤ÊƱµÁ¸ì |
| n | ²þ¹Ô¤ò¶èÊ̤¹¤ë¥Þ¥Ã¥Á(¹à9.6.3.5¤ò»²¾È) |
| p | ÉôʬŪ¤Ê²þ¹Ô¤ò¶èÊ̤¹¤ë¥Þ¥Ã¥Á(¹à9.6.3.5¤ò»²¾È) |
| q | »Ä¤ê¤ÎRE¤Ï¥ê¥Æ¥é¥ë("°úÍÑÉäÉÕ¤±¤µ¤ì¤¿")ʸ»úÎ󡢤¹¤Ù¤ÆÉáÄ̤Îʸ»ú |
| s | ²þ¹Ô¤ò¶èÊ̤·¤Ê¤¤¥Þ¥Ã¥Á(¥Ç¥Õ¥©¥ë¥È) |
| t | ¸·¤·¤á¤Î¹½Ê¸(¥Ç¥Õ¥©¥ë¥È¡¢¸å½Ò) |
| w | ÉôʬŪ¤Ê²þ¹Ô¶èÊ̤εÕ("¥ï¥¤¥¢¡¼¥É")¥Þ¥Ã¥Á(¹à9.6.3.5¤ò»²¾È) |
| x | ³ÈÄ¥¹½Ê¸(¸å½Ò) |
Ëä¤á¹þ¤ß¥ª¥×¥·¥ç¥ó¤Ï¤½¤ÎʤӤνªÃ¼)¤Ç͸ú¤Ë¤Ê¤ê¤Þ¤¹¡£ ARE¤ÎÀèƬ¤Ç¤Î¤ßÍøÍѲÄǽ¤Ç¤¢¤ê¡¢¤½¤Î¸å¤Ï»ÈÍѤµ¤ì¤Þ¤»¤ó¡£
¤¹¤Ù¤Æ¤Îʸ»ú¤¬°ÕÌ£¤ò»ý¤Ä¡¢Ä̾ï¤Î(¸·¤·¤á¤Î)RE¹½Ê¸¤Ë²Ã¤¨¡¢xËä¤á¹þ¤ß¥ª¥×¥·¥ç¥ó¤ò»ØÄꤹ¤ë¤³¤È¤ÇÍøÍѤǤ¤ë³ÈÄ¥¹½Ê¸¤¬¤¢¤ê¤Þ¤¹¡£ ³ÈÄ¥¹½Ê¸¤Ç¤Ï¡¢REÆâ¤Î¶õÇòʸ»ú¤Ï̵»ë¤µ¤ì¡¢#¤È¤½¤Î¸å¤Î²þ¹Ô(¤â¤·¤¯¤ÏRE¤Î½ªÃ¼)¤Î´Ö¤Î¤¹¤Ù¤Æ¤Îʸ»ú¤âƱÍͤǤ¹¡£ ¤³¤ì¤Ë¤è¤ê¡¢ÃÊÍîÉÕ¤±¤äÊ£»¨¤ÊRE¤Î¥³¥á¥ó¥ÈÉÕ¤±¤¬²Äǽ¤Ë¤Ê¤ê¤Þ¤¹¡£ ´ðËܵ¬Â§¤ËÂФ·¤Æ3¤Ä¤ÎÎã³°¤¬¤¢¤ê¤Þ¤¹¡£
ľÁ°¤Ë\¤¬ÉÕ¤¤¤¿¶õÇòʸ»ú¤â¤·¤¯¤Ï#¤ÏÊÝ»ý¤µ¤ì¤Þ¤¹¡£
¥Ö¥é¥±¥Ã¥È¼°Æâ¤Î¶õÇòʸ»ú¤â¤·¤¯¤Ï#¤ÏÊÝ»ý¤µ¤ì¤Þ¤¹¡£
ARE¤Î(?:¤äBRE¤Î\(¤Ê¤É¤ÎÊ£¿ôʸ»ú¥·¥ó¥Ü¥ë¤Ç¤Ï¡¢¶õÇòʸ»ú¤È¥³¥á¥ó¥È¤ÏÉÔÀµ¤Ç¤¹¡£
³ÈÄ¥¹½Ê¸¤Î¶õÇòʸ»ú¤È¤Ï¡¢¶õÇò¡¢¥¿¥Ö²þ¹Ô¡¢spaceʸ»ú¥¯¥é¥¹¤Ë°¤¹¤ëʸ»ú¤Ç¤¹¡£
ºÇ¸å¤Ë¡¢ARE¤Î¥Ö¥é¥±¥Ã¥È¼°¤Î³°Â¦¤Ç¤Ï¡¢(?#ttt)¤È¤¤¤¦Ê¤Ӥϥ³¥á¥ó¥È¤Ë¤Ê¤ê¤Þ¤¹¡£ (¤³¤³¤Çttt¤Ï)¤ò´Þ¤Þ¤Ê¤¤Ç¤°Õ¤Î¥Æ¥¥¹¥È¤Ç¤¹¡£) ·«¤êÊÖ¤·¤Ë¤Ê¤ê¤Þ¤¹¤¬¡¢¤³¤ì¤Ï(?:¤Ê¤É¤ÎÊ£¿ôʸ»ú¥·¥ó¥Ü¥ë¤Îʸ»ú´Ö¤Ç¤Ï»ÈÍѤǤ¤Þ¤»¤ó¡£ ¤³¤¦¤·¤¿¥³¥á¥ó¥È¤Ï¼ÂÍÑÀ¤è¤ê¤âÎò»ËŪ¤Ê²Ã¹©ÉʤǤ¹¡£ ¤½¤Î¤¿¤á¡¢¤³¤Î»ÈÍѤϴ«¤á¤Þ¤»¤ó¡£Âå¤ï¤ê¤Ë³ÈÄ¥¹½Ê¸¤ò»ÈÍѤ·¤Æ¤¯¤À¤µ¤¤¡£
½é¤á¤Ë***=·èÄê»Ò¤¬»ØÄꤵ¤ì¡¢¥æ¡¼¥¶¤ÎÆþÎϤ¬RE¤Ç¤Ï¤Ê¤¯¥ê¥Æ¥é¥ë¤È¤·¤Æ°·¤ï¤ì¤ë¾ì¹ç¡¢¤³¤ì¤é¤Î¥á¥¿¹½Ê¸³ÈÄ¥¤Ï»ÈÍѤǤ¤Þ¤»¤ó¡£
RE¤¬Ê¸»úÎó¤ÎÃæ¤Î1¤Ä°Ê¾å¤ÎÉôʬʸ»úÎó¤È¥Þ¥Ã¥Á¤¹¤ë¾ì¹ç¤Ë¤ª¤¤¤Æ¡¢RE¤ÏºÇ½é¤Ë¥Þ¥Ã¥Á¤¬»Ï¤Þ¤Ã¤¿Éôʬʸ»úÎó¤È¥Þ¥Ã¥Á¤·¤Þ¤¹¡£ ¤½¤Î°ÌÃÖ¤«¤é¤Þ¤¿1¤Ä°Ê¾å¤ÎÉôʬʸ»úÎó¤È¥Þ¥Ã¥Á¤·¤¿ºÝ¤Ï¡¢Àµµ¬É½¸½¤Ï¤½¤ÎÍ¥Àè½ç°Ì¤Ë¤è¤Ã¤Æ¡¢ºÇŤ⤷¤¯¤ÏºÇû¤Îʸ»úÎó¤Î¤É¤Á¤é¤òÁªÂò¤¹¤ë¤«¤ò·èÄꤷ¤Þ¤¹¡£
¤Û¤È¤ó¤É¤Î¥¢¥È¥à¤È¤¹¤Ù¤Æ¤ÎÀ©Ìó¤Ë¤ÏÍ¥Àè½ç°Ì¤Ï¤¢¤ê¤Þ¤»¤ó¡£ ³ç¸ÌÉÕ¤±¤µ¤ì¤¿RE¤ÏRE¤ÈƱ°ì¤ÎÍ¥Àè½ç°Ì¤ò»ý¤Á¤Þ¤¹¡£(Í¥Àè½ç°Ì¤òÁ´¤¯»ý¤¿¤Ê¤¤²ÄǽÀ¤â¤¢¤ê¤Þ¤¹¡£) {m}¤â¤·¤¯¤Ï{m}?½¤¾þ»Ò¤ò»ý¤Ä½¤¾þ¤µ¤ì¤¿¥¢¥È¥à¤Ï¡¢¥¢¥È¥à¼«¿È¤ÈƱ°ì¤ÎÍ¥Àè½ç°Ì¤ò»ý¤Á¤Þ¤¹¡£(Í¥Àè½ç°Ì¤òÁ´¤¯»ý¤¿¤Ê¤¤²ÄǽÀ¤â¤¢¤ê¤Þ¤¹¡£) ¾¤ÎÄ̾ï¤Î½¤¾þ»Ò({m,n}¡¢m¤Èn¤¬Åù¤·¤¤¾ì¹ç¤â´Þ¤ß¤Þ¤¹)¤ò»ý¤Ä½¤¾þ¤µ¤ì¤¿¥¢¥È¥à¤ÏºÇĹ¥Þ¥Ã¥Á¤ò»ÈÍѤ·¤Þ¤¹¡£ ¾¤ÎÍßÄ¥¤é¤Ê¤¤½¤¾þ»Ò({m,n}?¡¢m¤Èn¤¬Åù¤·¤¤¾ì¹ç¤â´Þ¤ß¤Þ¤¹)¤ò»ý¤Ä½¤¾þ¤µ¤ì¤¿¥¢¥È¥à¤ÏºÇû¥Þ¥Ã¥Á¤ò»ÈÍѤ·¤Þ¤¹¡£ ¥Ö¥é¥ó¥Á¤ÏÍ¥Àè½ç°Ì¤ò»ý¤ÄºÇ½é¤Î½¤¾þ¤µ¤ì¤¿¥¢¥È¥à¤ÈƱ°ì¤ÎÍ¥Àè½ç°Ì¤ò»ý¤Á¤Þ¤¹¡£ |±é»»»Ò¤ÇÀܳ¤µ¤ì¤¿2¤Ä°Ê¾å¤Î¥Ö¥é¥ó¥Á¤«¤é¤Ê¤ëRE¤ÏºÇĹ¥Þ¥Ã¥Á¤ò»ÈÍѤ·¤Þ¤¹¡£
REÁ´ÂΤؤΥޥåÁÍѤε¬Â§¤Ë¤è¤Ã¤Æ²Ý¤»¤é¤ì¤¿À©Ìó¤Ë½¾¤¤¡¢Éû¼°¤Ï¤½¤ÎÍ¥Àè½ç°Ì¤Ë´ð¤Å¤¤¤ÆºÇŤ⤷¤¯¤ÏºÇû¤ÎÉôʬʸ»úÎó¤Ë¥Þ¥Ã¥Á¤·¤Þ¤¹¡£ ¤Þ¤¿¡¢¤½¤ÎREÆâ¤ÇÀè¤Ë»Ï¤Þ¤ëÉû¼°¤ÏÍ¥ÀèÅÙ¤ò¸å¤Ë»Ï¤Þ¤ëÉû¼°¤Ë°ú¤·Ñ¤®¤Þ¤¹¡£ ¤³¤Î¤è¤¦¤Ë¤·¤Æ¡¢³°Â¦¤ÎÉû¼°¤Ï¤½¤ÎÍ×ÁǤȤʤëÉû¼°¤ËÍ¥ÀèÅÙ¤ò°ú¤·Ñ¤°¤³¤È¤ËÃí°Õ¤·¤Æ¤¯¤À¤µ¤¤¡£
{1,1}¤ª¤è¤Ó{1,1}?½¤¾þ»Ò¤òÉû¼°¤â¤·¤¯¤ÏREÁ´ÂΤ˻ÈÍѤ·¤Æ¡¢¤½¤ì¤¾¤ì¡¢ºÇĹ¡¢ºÇû¤ÎÍ¥Àè½ç°Ì¤ò¶¯À©¤¹¤ë¤³¤È¤¬²Äǽ¤Ç¤¹¡£
¥Þ¥Ã¥Á¤ÎŤµ¾È¹çÍ×ÁǤǤϤʤ¯Ê¸»úÎó¤Ç¬¤é¤ì¤Þ¤¹¡£ ¶õʸ»úÎó¤ÏÁ´¤¯¥Þ¥Ã¥Á¤¹¤ëÍ×ÁǤ¬¤Ê¤¤Ê¸»úÎó¤è¤ê¤âŤ¤¤È¹Í¤¨¤é¤ì¤Þ¤¹¡£ Î㤨¤Ð¡¢bb*¤Ïabbbc¤Î¿¿Ãæ¤Î3ʸ»ú¤È¥Þ¥Ã¥Á¤·¡¢(week|wee)(night|knights)¤Ïweeknights¤Î¤¹¤Ù¤Æ¤Î10ʸ»ú¤È¥Þ¥Ã¥Á¤·¡¢abc¤ËÂФ·¤Æ(.*).*¤¬¥Þ¥Ã¥Á¤µ¤ì¤ë¤È¡¢³ç¸ÌÆâ¤ÎÉôʬÀµµ¬É½¸½¤Ï3¤Ä¤Îʸ»ú¤¹¤Ù¤Æ¤Ë¥Þ¥Ã¥Á¤·¡¢bc¤ËÂФ·¤Æ(a*)*¤¬¥Þ¥Ã¥Á¤µ¤ì¤ë¤È¡¢Á´ÂΤÎRE¤È³ç¸ÌÆâ¤ÎÀµµ¬É½¸½¤Ï¶õʸ»úÎó¤Ë¥Þ¥Ã¥Á¤·¤Þ¤¹¡£
¤â¤·Âçʸ»ú¾®Ê¸»ú¤ò¶èÊ̤·¤Ê¤¤¥Þ¥Ã¥Á¥ó¥°¤¬»ØÄꤵ¤ì¤ë¤È¡¢¥¢¥ë¥Õ¥¡¥Ù¥Ã¥Èʸ»ú¤ÎÂçʸ»ú¾®Ê¸»ú¤Î¶èÊ̤¬Á´¤¯¤Ê¤¯¤Ê¤Ã¤¿¤ÈƱ¤¸¸ú²Ì¤ò¤¢¤¿¤¨¤Þ¤¹¡£ ¥Ö¥é¥±¥Ã¥È¼°¤Î³°Â¦¤Ë¥¢¥ë¥Õ¥¡¥Ù¥Ã¥È¤ÎÂçʸ»ú¾®Ê¸»ú¤¬º®¤¶¤Ã¤¿Ä̾ï¤Îʸ»ú¤¬½Ð¤Æ¤¤¿¾ì¹ç¡¢Î㤨¤Ð¡¢x¤¬[xX]¤È¤Ê¤ë¤è¤¦¤ËÂçʸ»ú¾®Ê¸»ú¤È¤â¤Ë¥Ö¥é¥±¥Ã¥È¼°¤Ë¼Â¼ÁŪ¤Ëž´¹¤µ¤ì¤Þ¤¹¡£ ¥Ö¥é¥±¥Ã¥È¼°¤ÎÃæ¤Ë¸½¤ï¤ì¤¿»þ¤Ï¡¢(Î㤨¤Ð¡¢)[x]¤¬[xX]¤È¤Ê¤ê¡¢¤Þ¤¿[^x]¤¬[^xX]¤È¤Ê¤ë¤è¤¦¤Ë¡¢¤¹¤Ù¤Æ¤ÎÂçʸ»ú¾®Ê¸»ú¤½¤ì¤¾¤ì¤ÎÂФ¬¥Ö¥é¥±¥Ã¥È¼°¤ËÄɲ䵤ì¤Þ¤¹¡£
²þ¹Ô¤ò¶èÊ̤¹¤ë¥Þ¥Ã¥Á¤¬»ØÄꤵ¤ì¤ë¤È¡¢.¤È^¤ò»ÈÍѤ¹¤ë¥Ö¥é¥±¥Ã¥È¼°¤Ï(RE¤¬ÌÀ¼¨Åª¤ËÄ´À°¤µ¤ì¤Æ¤¤¤¿¤È¤·¤Æ¤â¥Þ¥Ã¥Á¤¬²þ¹Ô¤ò¸Ù¤é¤Ê¤¤¤è¤¦¤Ë¤¹¤ë¤¿¤á¤Ë)²þ¹Ôʸ»ú¤Ë¥Þ¥Ã¥Á¤·¤Ê¤¯¤Ê¤ê¤Þ¤¹¡£ ¤Þ¤¿¡¢^¤È$¤Ï¤½¤ì¤¾¤ì²þ¹Ôľ¸å¤ÈľÁ°¤Î¶õʸ»úÎó¤Ë¥Þ¥Ã¥Á¤·¡¢¤µ¤é¤Ë¡¢¤½¤ì¤¾¤ìʸ»úÎó¤ÎÀèƬ¤ÈËöÈø¤Ë¥Þ¥Ã¥Á¤·¤Þ¤¹¡£ ¤·¤«¤·¡¢ARE¥¨¥¹¥±¡¼¥×¤Î\A¤È\Z¤Ï¡¢·Ñ³¤·¤Æ¡¢Ê¸»úÎó¤ÎÀèƬ¤ÈËöÈø¤Î¤ß¤Ë¥Þ¥Ã¥Á¤·¤Þ¤¹¡£
ÉôʬŪ¤Ë²þ¹Ô¤ò¶èÊ̤¹¤ë¥Þ¥Ã¥Á¤¬»ØÄꤵ¤ì¤ë¤È¡¢.¤È¥Ö¥é¥±¥Ã¥È¼°¤Ï²þ¹Ô¤ò¶èÊ̤¹¤ë¥Þ¥Ã¥Á¤ò¹Ô¤Ê¤¦¤è¤¦¤Ë¤Ê¤ê¤Þ¤¹¤¬¡¢^¤È$¤ÏÊѹ¹¤µ¤ì¤Þ¤»¤ó¡£
ÉôʬŪ¤Ë²þ¹Ô¤òµÕ¶èÊ̤¹¤ë¥Þ¥Ã¥Á¤¬»ØÄꤵ¤ì¤ë¤È¡¢ ^¤È$¤Ï²þ¹Ô¤ò¶èÊ̤¹¤ë¥Þ¥Ã¥Á¤ò¹Ô¤Ê¤¦¤è¤¦¤Ë¤Ê¤ê¤Þ¤¹¤¬¡¢.¤È¥Ö¥é¥±¥Ã¥È¼°¤ÏÊѹ¹¤µ¤ì¤Þ¤»¤ó¡£ ¤³¤ì¤Ï¤¢¤Þ¤êÍÍѤǤϤ¢¤ê¤Þ¤»¤ó¡£ÂоÎÀ¤Î¤¿¤á¤ËÄ󶡤µ¤ì¤Æ¤¤¤Þ¤¹¡£
ËܼÂÁõ¤Ç¤ÏRE¤ÎŤµ¤Ë´Ø¤¹¤ëÀ©¸Â¤Ï¤¢¤ê¤Þ¤»¤ó¡£ ¤·¤«¤·¡¢°Ü¿¢À¤ò¹â¤á¤¿¤¤¥×¥í¥°¥é¥à¤Ç¤Ï¡¢256¥Ð¥¤¥È¤ò±Û¤¨¤ëRE¤ò»ÈÍѤ¹¤Ù¤¤Ç¤Ï¤¢¤ê¤Þ¤»¤ó¡£ POSIX¸ß´¹¤Î¼ÂÁõ¤Ç¤Ï¤½¤¦¤·¤¿RE¤Ç¤Ïº®Í𤹤ë²ÄǽÀ¤¬¤¢¤ê¤Þ¤¹¡£
ARE¤Îµ¡Ç½¤ÎÆâ¡¢POSIX ERE¤È¼Â¼ÁŪ¤ÊÈó¸ß´¹À¤¬¤¢¤ë¤Î¤Ï¡¢\¤¬¥Ö¥é¥±¥Ã¥È¼°¤ÎÆ⦤ÇÆüì¤Ê°ÕÌ£¤ò¼º¤ï¤Ê¤¤¤È¤¤¤¦ÅÀ¤Î¤ß¤Ç¤¹¡£ ¾¤Î¤¹¤Ù¤Æ¤ÎAREµ¡Ç½¤Ï¡¢POSIX ERE¤Ç¤ÏÉÔÀµ¡¢Ì¤ÄêµÁ¡¢Ì¤»ØÄê¤Ê¸ú²Ì¤È¤Ê¤ë¹½Ê¸¤ò»ÈÍѤ·¤Æ¤¤¤Þ¤¹¡£ ·èÄê»Ò¤Î***¹½Ê¸¤Ê¤É¤ÏBRE¤ª¤è¤ÓERE¤ÎPOSIX¹½Ê¸¤Ë¤Ï¤¢¤ê¤Þ¤»¤ó¡£
¿¤¯¤ÎARE¼°¤ÏPerl¤«¤é¼Ú¤ê¤é¤ì¤¿¤â¤Î¤Ç¤¹¡£ ¤·¤«¤·¡¢¤¤¤¯¤Ä¤«¤ÏÀ°Íý¤µ¤ì¡¢Perl¤Î³ÈÄ¥¤Î¤¤¤¯¤Ä¤«¤Ï¸ºß¤·¤Þ¤»¤ó¡£ Ãí°Õ¤¹¤Ù¤Èó¸ß´¹À¤Ë¤Ï¡¢\b¡¢\B¡¢²þ¹Ô¤Î¼è°·¤¤¤Ë´Ø¤¹¤ëÆüì¤ÊÁ¼Ã֤ηçÍî¡¢²þ¹Ô¤ò¶èÊ̤¹¤ë¥Þ¥Ã¥Á¤Ë±Æ¶Á¤¹¤ëÅÀ¤Ë¤Ä¤¤¤ÆÊ䤷¤¿¥Ö¥é¥±¥Ã¥È¼°¤ÎÄɲᢳç¸Ì¤ÈÀè¹Ô¸¡º÷À©ÌóÆâ¤Î¸åÊý»²¾È¤Ë¤Ä¤¤¤Æ¤ÎÀ©¸Â¡¢ºÇĹ/ºÇû(ºÇ½é¤Ë¥Þ¥Ã¥Á¤¹¤ë¤Ç¤Ï¤Ê¤¯)¥Þ¥Ã¥Á¤Î¥»¥Þ¥ó¥Æ¥£¥Ã¥¯¤¬¤¢¤ê¤Þ¤¹¡£
PostgreSQL¥ê¥ê¡¼¥¹7.4¤è¤êÁ°¤ÇǧÃΤµ¤ì¤¿¡¢ARE¤ÈERE¹½Ê¸´Ö¤ÇÂ礤ÊÈó¸ß´¹¤Ê2¤Ä¤¢¤ê¤Þ¤¹¡£
ARE¤Ç¤Ï¡¢\¤Î¸å¤Ë±Ñ¿ô»ú¤¬Â³¤¯¤â¤Î¤Ï¥¨¥¹¥±¡¼¥×¤â¤·¤¯¤Ï¥¨¥é¡¼¤È¤Ê¤ê¤Þ¤¹¡£ °ÊÁ°¤Î¥ê¥ê¡¼¥¹¤Ç¤Ï¡¢¤³¤ì¤Ïñ¤Ë¡¢±Ñ¿ô»ú¤òµ½Ò¤¹¤ë¾¤ÎÊýË¡¤Ç¤·¤¿¡£ ¤³¤ì¤Ï¡¢Â礤ÊÌäÂê¤Ë¤Ï¤Ê¤é¤Ê¤¤¤Ï¤º¤Ç¤¹¡£ °ÊÁ°¤Î¥ê¥ê¡¼¥¹¤Ç¤Ï¤³¤¦¤·¤¿Ê¤Ӥòµ½Ò¤¹¤ëÍýͳ¤¬¤Ê¤¤¤«¤é¤Ç¤¹¡£
ARE¤Ç¤Ï¡¢\¤Ï[]Æâ¤Ç¤âÆÃÊ̤Êʸ»ú¤Ç¤¹¡£ ½¾¤Ã¤Æ¡¢¥Ö¥é¥±¥Ã¥È¼°¤Ç¤Ï\¤ò\\¤Èµ½Ò¤·¤Ê¤±¤ì¤Ð¤Ê¤ê¤Þ¤»¤ó¡£
¤³¤ì¤é¤Î°ã¤¤¤Ë¤è¤ê¤Û¤È¤ó¤É¤Î¥¢¥×¥ê¥±¡¼¥·¥ç¥ó¤Ç¤ÏÌäÂê¤Ë¤Ê¤ë¤³¤È¤Ï¤¢¤Þ¤ê¤¢¤ê¤Þ¤»¤ó¤¬¡¢É¬Íפ˱þ¤¸¤Æregex_flavor¤òextended¤ËÀßÄꤹ¤ë¤³¤È¤Ç²óÈò¤¹¤ë¤³¤È¤¬¤Ç¤¤Þ¤¹¡£
BRE¤ÏERE¤È¤¤¤¯¤Ä¤«¤ÎÌ̤ˤª¤¤¤Æ°Û¤Ê¤ê¤Þ¤¹¡£ |¡¢+¡¢?¤ÏÉáÄ̤Îʸ»ú¤Ç¤¢¤ê¡¢¤½¤ì¤é¤Îµ¡Ç½¤ÈÅù²Á¤Ê¤â¤Î¤Ï¤¢¤ê¤Þ¤»¤ó¡£ ¥Ð¥¦¥ó¥É¤Î¶èÀÚ¤ê¤Ï\{¤È\}¤Ç¤¢¤ê¡¢{¤È}¼«¿È¤ÏÉáÄ̤Îʸ»ú¤Ç¤¹¡£ Éû¼°¤òÆþ¤ì»Ò¤Ë¤¹¤ë¤¿¤á¤Î³ç¸Ì¤Ï\(¤È\)¤Ç¤¢¤ê¡¢(¤È)¼«¿È¤ÏÉáÄ̤Îʸ»ú¤Ç¤¹¡£ ^¤Ï¡¢RE¤ÎÀèƬ¤Ë¤¢¤ë¾ì¹ç¤ä³ç¸ÌÆâ¤ÎÉû¼°¤ÎÀèƬ¤Î¾ì¹ç¤ò½ü¤¡¢ÉáÄ̤Îʸ»ú¤Ç¤¹¡£ $¤Ï¡¢RE¤ÎËöÈø¤Ë¤¢¤ë¾ì¹ç¤ä³ç¸ÌÆâ¤ÎÉû¼°¤ÎËöÈø¤Î¾ì¹ç¤ò½ü¤¡¢ÉáÄ̤Îʸ»ú¤Ç¤¹¡£ ¤Þ¤¿¡¢*¤ÏRE¤ÎÀèƬ¤Ë¤¢¤ë¾ì¹ç¤ä³ç¸ÌÆâ¤ÎÉû¼°¤ÎÀèƬ¤Ë¤¢¤ë¾ì¹ç¤Ë¤ÏÉáÄ̤Îʸ»ú¤Ë¤Ê¤ê¤Þ¤¹¡£(¤½¤ÎÁ°¤Ë^¤¬ÉÕ¤¤¤Æ¤¤¤ë²ÄǽÀ¤â¤¢¤ê¤Þ¤¹¡£) ºÇ¸å¤Ë¡¢1·å¤Î¸åÊý»²¾È¤ò»ÈÍѤ¹¤ë¤³¤È¤¬¤Ç¤¡¢¤Þ¤¿¡¢\<¤È\>¤Ï¤½¤ì¤¾¤ì[[:<:]]¤È[[:>:]]¤ÈƱµÁ¤Ç¤¹¡£ ¾¤Î¥¨¥¹¥±¡¼¥×¤Ï»ÈÍѤǤ¤Þ¤»¤ó¡£
| Á°¤Î¥Ú¡¼¥¸ | ¥Û¡¼¥à | ¼¡¤Î¥Ú¡¼¥¸ |
| ¥Ð¥¤¥Ê¥êÎó´Ø¿ô¤È±é»»»Ò | ¾å¤ËÌá¤ë | ¥Ç¡¼¥¿·¿½ñ¼°ÀßÄê´Ø¿ô |