<!DOCTYPE html> <html> <head> </head> <body> <dl style="line-height: 1.5; margin-left: 2em"> <dt style="clear: both; float: left; font-weight: bold; width: 8em">Author</dt> <dd style="margin-left: 8.5em">Kouhei Sutou <kou****@clear*****></dd> <dt style="clear: both; float: left; font-weight: bold; width: 8em">Date</dt> <dd style="margin-left: 8.5em">2015-10-13 22:16:57 +0900 (Tue, 13 Oct 2015)</dd> <dt style="clear: both; float: left; font-weight: bold; width: 8em">New Revision</dt> <dd style="margin-left: 8.5em"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a">d0b2d675e0a8c570a83484977bd7cf77fa8fc60a</a></dd> <dt style="clear: both; float: left; font-weight: bold; width: 8em">Message</dt> <dd style="margin-left: 8.5em"><pre style="border: 1px solid #aaa; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; padding: 0.5em; width: auto">Support regexp search by @~ TODO: * Document</pre></dd> <dt style="clear: both; float: left; font-weight: bold; width: 8em">Added files</dt> <dd style="margin-left: 8.5em"> <ul> <li><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-0607b67b2e916fa1482cc0bec3116016">expected/regexp/text/begin-of-text/bitmapscan.out</a></li> <li><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-b8f3d148b1185da2f2933913e7b26b6c">expected/regexp/text/begin-of-text/indexscan.out</a></li> <li><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-7664133b25e2d1628717fc617c9d537a">expected/regexp/text/begin-of-text/seqscan.out</a></li> <li><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-9876beefd5239369cf1a9f9fd1540c4c">expected/regexp/text/end-of-text/bitmapscan.out</a></li> <li><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a9add798dc7a3265eb2d0c9810023ec7">expected/regexp/text/end-of-text/indexscan.out</a></li> <li><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-1ffa4fbb9f73d376f3b41ab2fbaf1054">expected/regexp/text/end-of-text/seqscan.out</a></li> <li><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-9cca9adea479adcd3c5ee9aa3a4a894f">expected/regexp/text/exact/bitmapscan.out</a></li> <li><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-1b2d43d04b9cc0422081da29a6f64bcb">expected/regexp/text/exact/indexscan.out</a></li> <li><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-32dd1cfe1bf9d7939d85f31e2ededa67">expected/regexp/text/exact/seqscan.out</a></li> <li><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-3b7c36b71e34a74f82a8fe9c6f532d9d">expected/regexp/text/partial/bitmapscan.out</a></li> <li><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-49b2007e2591e095ca195c18524be214">expected/regexp/text/partial/indexscan.out</a></li> <li><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-d707d2287c0429a83717c242b24fd46e">expected/regexp/text/partial/seqscan.out</a></li> <li><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-5195066c0f7a9e4be4462492a980f84c">sql/regexp/text/begin-of-text/bitmapscan.sql</a></li> <li><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-40c61eac600f3e7a527dc3a3e7ccba10">sql/regexp/text/begin-of-text/indexscan.sql</a></li> <li><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-3312747c297cb0084642132fb1f495c5">sql/regexp/text/begin-of-text/seqscan.sql</a></li> <li><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-174143402ca4159476741b9624128c0c">sql/regexp/text/end-of-text/bitmapscan.sql</a></li> <li><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-33d37f33461911a353e8e02d03689356">sql/regexp/text/end-of-text/indexscan.sql</a></li> <li><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-066d88d6922a09290177a18f782bab88">sql/regexp/text/end-of-text/seqscan.sql</a></li> <li><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-b5c5028a44dc56826ca4242cc15309ea">sql/regexp/text/exact/bitmapscan.sql</a></li> <li><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-349f855144d7f14cbfe9e814d9137b5a">sql/regexp/text/exact/indexscan.sql</a></li> <li><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-2cc93289c5b5d6f3a9f6b3e303ba9a0f">sql/regexp/text/exact/seqscan.sql</a></li> <li><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-05190fdb1555dd79d40f0e8d44f1450e">sql/regexp/text/partial/bitmapscan.sql</a></li> <li><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-54980abe4075aa0f6ed11f145a7fd5ef">sql/regexp/text/partial/indexscan.sql</a></li> <li><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-62c48661d6da6b991f305b6153fc3c7d">sql/regexp/text/partial/seqscan.sql</a></li> </ul> </dd> <dt style="clear: both; float: left; font-weight: bold; width: 8em">Modified files</dt> <dd style="margin-left: 8.5em"> <ul> <li><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-c360e0538b5244106e4378d0bd562c21">pgroonga--0.9.0--1.0.0.sql</a></li> <li><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49">pgroonga.c</a></li> <li><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-32975b580c6e9ac93875f68732469121">pgroonga.h</a></li> <li><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773">pgroonga.sql</a></li> </ul> </dd> </dl> <div class="diff-section" style="clear: both"> <table style="border-collapse: collapse; border: 1px solid #aaa"> <thead> <tr class="diff-header" style="border: 1px solid #aaa"> <td colspan="3"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"> Added: expected/regexp/text/begin-of-text/bitmapscan.out (+20 -0) 100644 =================================================================== </pre> </td> </tr> </thead> <tbody> <tr> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-0607b67b2e916fa1482cc0bec3116016">...</a>                                         </pre> </th> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-0607b67b2e916fa1482cc0bec3116016">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-0607b67b2e916fa1482cc0bec3116016R1">1</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-0607b67b2e916fa1482cc0bec3116016R2">2</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-0607b67b2e916fa1482cc0bec3116016R3">3</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-0607b67b2e916fa1482cc0bec3116016R4">4</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-0607b67b2e916fa1482cc0bec3116016R5">5</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-0607b67b2e916fa1482cc0bec3116016R6">6</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-0607b67b2e916fa1482cc0bec3116016R7">7</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-0607b67b2e916fa1482cc0bec3116016R8">8</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-0607b67b2e916fa1482cc0bec3116016R9">9</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-0607b67b2e916fa1482cc0bec3116016R10">10</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-0607b67b2e916fa1482cc0bec3116016R11">11</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-0607b67b2e916fa1482cc0bec3116016R12">12</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-0607b67b2e916fa1482cc0bec3116016R13">13</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-0607b67b2e916fa1482cc0bec3116016R14">14</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-0607b67b2e916fa1482cc0bec3116016R15">15</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-0607b67b2e916fa1482cc0bec3116016R16">16</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-0607b67b2e916fa1482cc0bec3116016R17">17</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-0607b67b2e916fa1482cc0bec3116016R18">18</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-0607b67b2e916fa1482cc0bec3116016R19">19</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-0607b67b2e916fa1482cc0bec3116016R20">20</a> </pre> </th> <td class="diff-content" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto">@@ -0,0 +1,20 @@ +CREATE TABLE memos ( + id integer, + content text +); +INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS.'); +INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine.'); +INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga.'); +CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); +SET enable_seqscan = off; +SET enable_indexscan = off; +SET enable_bitmapscan = on; +SELECT id, content + FROM memos + WHERE content @~ '\Agroonga'; + id | content +----+------------------------------------------ + 2 | Groonga is fast full text search engine. +(1 row) + +DROP TABLE memos; </pre> </td> </tr> </tbody> </table> <table style="border-collapse: collapse; border: 1px solid #aaa"> <thead> <tr class="diff-header" style="border: 1px solid #aaa"> <td colspan="3"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"> Added: expected/regexp/text/begin-of-text/indexscan.out (+20 -0) 100644 =================================================================== </pre> </td> </tr> </thead> <tbody> <tr> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-b8f3d148b1185da2f2933913e7b26b6c">...</a>                                         </pre> </th> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-b8f3d148b1185da2f2933913e7b26b6c">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-b8f3d148b1185da2f2933913e7b26b6cR1">1</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-b8f3d148b1185da2f2933913e7b26b6cR2">2</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-b8f3d148b1185da2f2933913e7b26b6cR3">3</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-b8f3d148b1185da2f2933913e7b26b6cR4">4</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-b8f3d148b1185da2f2933913e7b26b6cR5">5</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-b8f3d148b1185da2f2933913e7b26b6cR6">6</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-b8f3d148b1185da2f2933913e7b26b6cR7">7</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-b8f3d148b1185da2f2933913e7b26b6cR8">8</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-b8f3d148b1185da2f2933913e7b26b6cR9">9</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-b8f3d148b1185da2f2933913e7b26b6cR10">10</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-b8f3d148b1185da2f2933913e7b26b6cR11">11</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-b8f3d148b1185da2f2933913e7b26b6cR12">12</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-b8f3d148b1185da2f2933913e7b26b6cR13">13</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-b8f3d148b1185da2f2933913e7b26b6cR14">14</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-b8f3d148b1185da2f2933913e7b26b6cR15">15</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-b8f3d148b1185da2f2933913e7b26b6cR16">16</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-b8f3d148b1185da2f2933913e7b26b6cR17">17</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-b8f3d148b1185da2f2933913e7b26b6cR18">18</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-b8f3d148b1185da2f2933913e7b26b6cR19">19</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-b8f3d148b1185da2f2933913e7b26b6cR20">20</a> </pre> </th> <td class="diff-content" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto">@@ -0,0 +1,20 @@ +CREATE TABLE memos ( + id integer, + content text +); +INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS.'); +INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine.'); +INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga.'); +CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); +SET enable_seqscan = off; +SET enable_indexscan = on; +SET enable_bitmapscan = off; +SELECT id, content + FROM memos + WHERE content @~ '\Agroonga'; + id | content +----+------------------------------------------ + 2 | Groonga is fast full text search engine. +(1 row) + +DROP TABLE memos; </pre> </td> </tr> </tbody> </table> <table style="border-collapse: collapse; border: 1px solid #aaa"> <thead> <tr class="diff-header" style="border: 1px solid #aaa"> <td colspan="3"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"> Added: expected/regexp/text/begin-of-text/seqscan.out (+20 -0) 100644 =================================================================== </pre> </td> </tr> </thead> <tbody> <tr> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-7664133b25e2d1628717fc617c9d537a">...</a>                                         </pre> </th> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-7664133b25e2d1628717fc617c9d537a">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-7664133b25e2d1628717fc617c9d537aR1">1</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-7664133b25e2d1628717fc617c9d537aR2">2</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-7664133b25e2d1628717fc617c9d537aR3">3</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-7664133b25e2d1628717fc617c9d537aR4">4</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-7664133b25e2d1628717fc617c9d537aR5">5</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-7664133b25e2d1628717fc617c9d537aR6">6</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-7664133b25e2d1628717fc617c9d537aR7">7</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-7664133b25e2d1628717fc617c9d537aR8">8</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-7664133b25e2d1628717fc617c9d537aR9">9</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-7664133b25e2d1628717fc617c9d537aR10">10</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-7664133b25e2d1628717fc617c9d537aR11">11</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-7664133b25e2d1628717fc617c9d537aR12">12</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-7664133b25e2d1628717fc617c9d537aR13">13</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-7664133b25e2d1628717fc617c9d537aR14">14</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-7664133b25e2d1628717fc617c9d537aR15">15</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-7664133b25e2d1628717fc617c9d537aR16">16</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-7664133b25e2d1628717fc617c9d537aR17">17</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-7664133b25e2d1628717fc617c9d537aR18">18</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-7664133b25e2d1628717fc617c9d537aR19">19</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-7664133b25e2d1628717fc617c9d537aR20">20</a> </pre> </th> <td class="diff-content" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto">@@ -0,0 +1,20 @@ +CREATE TABLE memos ( + id integer, + content text +); +INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS.'); +INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine.'); +INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga.'); +CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); +SET enable_seqscan = on; +SET enable_indexscan = off; +SET enable_bitmapscan = off; +SELECT id, content + FROM memos + WHERE content @~ '\Agroonga'; + id | content +----+------------------------------------------ + 2 | Groonga is fast full text search engine. +(1 row) + +DROP TABLE memos; </pre> </td> </tr> </tbody> </table> <table style="border-collapse: collapse; border: 1px solid #aaa"> <thead> <tr class="diff-header" style="border: 1px solid #aaa"> <td colspan="3"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"> Added: expected/regexp/text/end-of-text/bitmapscan.out (+20 -0) 100644 =================================================================== </pre> </td> </tr> </thead> <tbody> <tr> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-9876beefd5239369cf1a9f9fd1540c4c">...</a>                                         </pre> </th> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-9876beefd5239369cf1a9f9fd1540c4c">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-9876beefd5239369cf1a9f9fd1540c4cR1">1</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-9876beefd5239369cf1a9f9fd1540c4cR2">2</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-9876beefd5239369cf1a9f9fd1540c4cR3">3</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-9876beefd5239369cf1a9f9fd1540c4cR4">4</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-9876beefd5239369cf1a9f9fd1540c4cR5">5</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-9876beefd5239369cf1a9f9fd1540c4cR6">6</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-9876beefd5239369cf1a9f9fd1540c4cR7">7</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-9876beefd5239369cf1a9f9fd1540c4cR8">8</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-9876beefd5239369cf1a9f9fd1540c4cR9">9</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-9876beefd5239369cf1a9f9fd1540c4cR10">10</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-9876beefd5239369cf1a9f9fd1540c4cR11">11</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-9876beefd5239369cf1a9f9fd1540c4cR12">12</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-9876beefd5239369cf1a9f9fd1540c4cR13">13</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-9876beefd5239369cf1a9f9fd1540c4cR14">14</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-9876beefd5239369cf1a9f9fd1540c4cR15">15</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-9876beefd5239369cf1a9f9fd1540c4cR16">16</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-9876beefd5239369cf1a9f9fd1540c4cR17">17</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-9876beefd5239369cf1a9f9fd1540c4cR18">18</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-9876beefd5239369cf1a9f9fd1540c4cR19">19</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-9876beefd5239369cf1a9f9fd1540c4cR20">20</a> </pre> </th> <td class="diff-content" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto">@@ -0,0 +1,20 @@ +CREATE TABLE memos ( + id integer, + content text +); +INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS'); +INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine'); +INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga'); +CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); +SET enable_seqscan = off; +SET enable_indexscan = off; +SET enable_bitmapscan = on; +SELECT id, content + FROM memos + WHERE content @~ 'groonga\z'; + id | content +----+------------------------------------------------------ + 3 | PGroonga is a PostgreSQL extension that uses Groonga +(1 row) + +DROP TABLE memos; </pre> </td> </tr> </tbody> </table> <table style="border-collapse: collapse; border: 1px solid #aaa"> <thead> <tr class="diff-header" style="border: 1px solid #aaa"> <td colspan="3"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"> Added: expected/regexp/text/end-of-text/indexscan.out (+20 -0) 100644 =================================================================== </pre> </td> </tr> </thead> <tbody> <tr> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a9add798dc7a3265eb2d0c9810023ec7">...</a>                                         </pre> </th> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a9add798dc7a3265eb2d0c9810023ec7">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a9add798dc7a3265eb2d0c9810023ec7R1">1</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a9add798dc7a3265eb2d0c9810023ec7R2">2</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a9add798dc7a3265eb2d0c9810023ec7R3">3</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a9add798dc7a3265eb2d0c9810023ec7R4">4</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a9add798dc7a3265eb2d0c9810023ec7R5">5</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a9add798dc7a3265eb2d0c9810023ec7R6">6</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a9add798dc7a3265eb2d0c9810023ec7R7">7</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a9add798dc7a3265eb2d0c9810023ec7R8">8</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a9add798dc7a3265eb2d0c9810023ec7R9">9</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a9add798dc7a3265eb2d0c9810023ec7R10">10</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a9add798dc7a3265eb2d0c9810023ec7R11">11</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a9add798dc7a3265eb2d0c9810023ec7R12">12</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a9add798dc7a3265eb2d0c9810023ec7R13">13</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a9add798dc7a3265eb2d0c9810023ec7R14">14</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a9add798dc7a3265eb2d0c9810023ec7R15">15</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a9add798dc7a3265eb2d0c9810023ec7R16">16</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a9add798dc7a3265eb2d0c9810023ec7R17">17</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a9add798dc7a3265eb2d0c9810023ec7R18">18</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a9add798dc7a3265eb2d0c9810023ec7R19">19</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a9add798dc7a3265eb2d0c9810023ec7R20">20</a> </pre> </th> <td class="diff-content" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto">@@ -0,0 +1,20 @@ +CREATE TABLE memos ( + id integer, + content text +); +INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS'); +INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine'); +INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga'); +CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); +SET enable_seqscan = off; +SET enable_indexscan = on; +SET enable_bitmapscan = off; +SELECT id, content + FROM memos + WHERE content @~ 'groonga\z'; + id | content +----+------------------------------------------------------ + 3 | PGroonga is a PostgreSQL extension that uses Groonga +(1 row) + +DROP TABLE memos; </pre> </td> </tr> </tbody> </table> <table style="border-collapse: collapse; border: 1px solid #aaa"> <thead> <tr class="diff-header" style="border: 1px solid #aaa"> <td colspan="3"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"> Added: expected/regexp/text/end-of-text/seqscan.out (+20 -0) 100644 =================================================================== </pre> </td> </tr> </thead> <tbody> <tr> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-1ffa4fbb9f73d376f3b41ab2fbaf1054">...</a>                                         </pre> </th> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-1ffa4fbb9f73d376f3b41ab2fbaf1054">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-1ffa4fbb9f73d376f3b41ab2fbaf1054R1">1</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-1ffa4fbb9f73d376f3b41ab2fbaf1054R2">2</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-1ffa4fbb9f73d376f3b41ab2fbaf1054R3">3</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-1ffa4fbb9f73d376f3b41ab2fbaf1054R4">4</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-1ffa4fbb9f73d376f3b41ab2fbaf1054R5">5</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-1ffa4fbb9f73d376f3b41ab2fbaf1054R6">6</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-1ffa4fbb9f73d376f3b41ab2fbaf1054R7">7</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-1ffa4fbb9f73d376f3b41ab2fbaf1054R8">8</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-1ffa4fbb9f73d376f3b41ab2fbaf1054R9">9</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-1ffa4fbb9f73d376f3b41ab2fbaf1054R10">10</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-1ffa4fbb9f73d376f3b41ab2fbaf1054R11">11</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-1ffa4fbb9f73d376f3b41ab2fbaf1054R12">12</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-1ffa4fbb9f73d376f3b41ab2fbaf1054R13">13</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-1ffa4fbb9f73d376f3b41ab2fbaf1054R14">14</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-1ffa4fbb9f73d376f3b41ab2fbaf1054R15">15</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-1ffa4fbb9f73d376f3b41ab2fbaf1054R16">16</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-1ffa4fbb9f73d376f3b41ab2fbaf1054R17">17</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-1ffa4fbb9f73d376f3b41ab2fbaf1054R18">18</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-1ffa4fbb9f73d376f3b41ab2fbaf1054R19">19</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-1ffa4fbb9f73d376f3b41ab2fbaf1054R20">20</a> </pre> </th> <td class="diff-content" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto">@@ -0,0 +1,20 @@ +CREATE TABLE memos ( + id integer, + content text +); +INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS'); +INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine'); +INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga'); +CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); +SET enable_seqscan = on; +SET enable_indexscan = off; +SET enable_bitmapscan = off; +SELECT id, content + FROM memos + WHERE content @~ 'groonga\z'; + id | content +----+------------------------------------------------------ + 3 | PGroonga is a PostgreSQL extension that uses Groonga +(1 row) + +DROP TABLE memos; </pre> </td> </tr> </tbody> </table> <table style="border-collapse: collapse; border: 1px solid #aaa"> <thead> <tr class="diff-header" style="border: 1px solid #aaa"> <td colspan="3"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"> Added: expected/regexp/text/exact/bitmapscan.out (+20 -0) 100644 =================================================================== </pre> </td> </tr> </thead> <tbody> <tr> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-9cca9adea479adcd3c5ee9aa3a4a894f">...</a>                                         </pre> </th> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-9cca9adea479adcd3c5ee9aa3a4a894f">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-9cca9adea479adcd3c5ee9aa3a4a894fR1">1</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-9cca9adea479adcd3c5ee9aa3a4a894fR2">2</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-9cca9adea479adcd3c5ee9aa3a4a894fR3">3</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-9cca9adea479adcd3c5ee9aa3a4a894fR4">4</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-9cca9adea479adcd3c5ee9aa3a4a894fR5">5</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-9cca9adea479adcd3c5ee9aa3a4a894fR6">6</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-9cca9adea479adcd3c5ee9aa3a4a894fR7">7</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-9cca9adea479adcd3c5ee9aa3a4a894fR8">8</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-9cca9adea479adcd3c5ee9aa3a4a894fR9">9</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-9cca9adea479adcd3c5ee9aa3a4a894fR10">10</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-9cca9adea479adcd3c5ee9aa3a4a894fR11">11</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-9cca9adea479adcd3c5ee9aa3a4a894fR12">12</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-9cca9adea479adcd3c5ee9aa3a4a894fR13">13</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-9cca9adea479adcd3c5ee9aa3a4a894fR14">14</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-9cca9adea479adcd3c5ee9aa3a4a894fR15">15</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-9cca9adea479adcd3c5ee9aa3a4a894fR16">16</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-9cca9adea479adcd3c5ee9aa3a4a894fR17">17</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-9cca9adea479adcd3c5ee9aa3a4a894fR18">18</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-9cca9adea479adcd3c5ee9aa3a4a894fR19">19</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-9cca9adea479adcd3c5ee9aa3a4a894fR20">20</a> </pre> </th> <td class="diff-content" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto">@@ -0,0 +1,20 @@ +CREATE TABLE memos ( + id integer, + content text +); +INSERT INTO memos VALUES (1, 'PostgreSQL'); +INSERT INTO memos VALUES (2, 'Groonga'); +INSERT INTO memos VALUES (3, 'PGroonga'); +CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); +SET enable_seqscan = off; +SET enable_indexscan = off; +SET enable_bitmapscan = on; +SELECT id, content + FROM memos + WHERE content @~ '\Agroonga\z'; + id | content +----+--------- + 2 | Groonga +(1 row) + +DROP TABLE memos; </pre> </td> </tr> </tbody> </table> <table style="border-collapse: collapse; border: 1px solid #aaa"> <thead> <tr class="diff-header" style="border: 1px solid #aaa"> <td colspan="3"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"> Added: expected/regexp/text/exact/indexscan.out (+20 -0) 100644 =================================================================== </pre> </td> </tr> </thead> <tbody> <tr> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-1b2d43d04b9cc0422081da29a6f64bcb">...</a>                                         </pre> </th> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-1b2d43d04b9cc0422081da29a6f64bcb">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-1b2d43d04b9cc0422081da29a6f64bcbR1">1</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-1b2d43d04b9cc0422081da29a6f64bcbR2">2</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-1b2d43d04b9cc0422081da29a6f64bcbR3">3</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-1b2d43d04b9cc0422081da29a6f64bcbR4">4</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-1b2d43d04b9cc0422081da29a6f64bcbR5">5</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-1b2d43d04b9cc0422081da29a6f64bcbR6">6</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-1b2d43d04b9cc0422081da29a6f64bcbR7">7</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-1b2d43d04b9cc0422081da29a6f64bcbR8">8</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-1b2d43d04b9cc0422081da29a6f64bcbR9">9</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-1b2d43d04b9cc0422081da29a6f64bcbR10">10</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-1b2d43d04b9cc0422081da29a6f64bcbR11">11</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-1b2d43d04b9cc0422081da29a6f64bcbR12">12</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-1b2d43d04b9cc0422081da29a6f64bcbR13">13</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-1b2d43d04b9cc0422081da29a6f64bcbR14">14</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-1b2d43d04b9cc0422081da29a6f64bcbR15">15</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-1b2d43d04b9cc0422081da29a6f64bcbR16">16</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-1b2d43d04b9cc0422081da29a6f64bcbR17">17</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-1b2d43d04b9cc0422081da29a6f64bcbR18">18</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-1b2d43d04b9cc0422081da29a6f64bcbR19">19</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-1b2d43d04b9cc0422081da29a6f64bcbR20">20</a> </pre> </th> <td class="diff-content" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto">@@ -0,0 +1,20 @@ +CREATE TABLE memos ( + id integer, + content text +); +INSERT INTO memos VALUES (1, 'PostgreSQL'); +INSERT INTO memos VALUES (2, 'Groonga'); +INSERT INTO memos VALUES (3, 'PGroonga'); +CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); +SET enable_seqscan = off; +SET enable_indexscan = on; +SET enable_bitmapscan = off; +SELECT id, content + FROM memos + WHERE content @~ '\Agroonga\z'; + id | content +----+--------- + 2 | Groonga +(1 row) + +DROP TABLE memos; </pre> </td> </tr> </tbody> </table> <table style="border-collapse: collapse; border: 1px solid #aaa"> <thead> <tr class="diff-header" style="border: 1px solid #aaa"> <td colspan="3"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"> Added: expected/regexp/text/exact/seqscan.out (+20 -0) 100644 =================================================================== </pre> </td> </tr> </thead> <tbody> <tr> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-32dd1cfe1bf9d7939d85f31e2ededa67">...</a>                                         </pre> </th> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-32dd1cfe1bf9d7939d85f31e2ededa67">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-32dd1cfe1bf9d7939d85f31e2ededa67R1">1</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-32dd1cfe1bf9d7939d85f31e2ededa67R2">2</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-32dd1cfe1bf9d7939d85f31e2ededa67R3">3</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-32dd1cfe1bf9d7939d85f31e2ededa67R4">4</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-32dd1cfe1bf9d7939d85f31e2ededa67R5">5</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-32dd1cfe1bf9d7939d85f31e2ededa67R6">6</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-32dd1cfe1bf9d7939d85f31e2ededa67R7">7</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-32dd1cfe1bf9d7939d85f31e2ededa67R8">8</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-32dd1cfe1bf9d7939d85f31e2ededa67R9">9</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-32dd1cfe1bf9d7939d85f31e2ededa67R10">10</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-32dd1cfe1bf9d7939d85f31e2ededa67R11">11</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-32dd1cfe1bf9d7939d85f31e2ededa67R12">12</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-32dd1cfe1bf9d7939d85f31e2ededa67R13">13</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-32dd1cfe1bf9d7939d85f31e2ededa67R14">14</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-32dd1cfe1bf9d7939d85f31e2ededa67R15">15</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-32dd1cfe1bf9d7939d85f31e2ededa67R16">16</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-32dd1cfe1bf9d7939d85f31e2ededa67R17">17</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-32dd1cfe1bf9d7939d85f31e2ededa67R18">18</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-32dd1cfe1bf9d7939d85f31e2ededa67R19">19</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-32dd1cfe1bf9d7939d85f31e2ededa67R20">20</a> </pre> </th> <td class="diff-content" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto">@@ -0,0 +1,20 @@ +CREATE TABLE memos ( + id integer, + content text +); +INSERT INTO memos VALUES (1, 'PostgreSQL'); +INSERT INTO memos VALUES (2, 'Groonga'); +INSERT INTO memos VALUES (3, 'PGroonga'); +CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); +SET enable_seqscan = on; +SET enable_indexscan = off; +SET enable_bitmapscan = off; +SELECT id, content + FROM memos + WHERE content @~ '\Agroonga\z'; + id | content +----+--------- + 2 | Groonga +(1 row) + +DROP TABLE memos; </pre> </td> </tr> </tbody> </table> <table style="border-collapse: collapse; border: 1px solid #aaa"> <thead> <tr class="diff-header" style="border: 1px solid #aaa"> <td colspan="3"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"> Added: expected/regexp/text/partial/bitmapscan.out (+21 -0) 100644 =================================================================== </pre> </td> </tr> </thead> <tbody> <tr> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-3b7c36b71e34a74f82a8fe9c6f532d9d">...</a>                                           </pre> </th> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-3b7c36b71e34a74f82a8fe9c6f532d9d">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-3b7c36b71e34a74f82a8fe9c6f532d9dR1">1</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-3b7c36b71e34a74f82a8fe9c6f532d9dR2">2</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-3b7c36b71e34a74f82a8fe9c6f532d9dR3">3</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-3b7c36b71e34a74f82a8fe9c6f532d9dR4">4</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-3b7c36b71e34a74f82a8fe9c6f532d9dR5">5</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-3b7c36b71e34a74f82a8fe9c6f532d9dR6">6</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-3b7c36b71e34a74f82a8fe9c6f532d9dR7">7</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-3b7c36b71e34a74f82a8fe9c6f532d9dR8">8</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-3b7c36b71e34a74f82a8fe9c6f532d9dR9">9</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-3b7c36b71e34a74f82a8fe9c6f532d9dR10">10</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-3b7c36b71e34a74f82a8fe9c6f532d9dR11">11</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-3b7c36b71e34a74f82a8fe9c6f532d9dR12">12</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-3b7c36b71e34a74f82a8fe9c6f532d9dR13">13</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-3b7c36b71e34a74f82a8fe9c6f532d9dR14">14</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-3b7c36b71e34a74f82a8fe9c6f532d9dR15">15</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-3b7c36b71e34a74f82a8fe9c6f532d9dR16">16</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-3b7c36b71e34a74f82a8fe9c6f532d9dR17">17</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-3b7c36b71e34a74f82a8fe9c6f532d9dR18">18</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-3b7c36b71e34a74f82a8fe9c6f532d9dR19">19</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-3b7c36b71e34a74f82a8fe9c6f532d9dR20">20</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-3b7c36b71e34a74f82a8fe9c6f532d9dR21">21</a> </pre> </th> <td class="diff-content" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto">@@ -0,0 +1,21 @@ +CREATE TABLE memos ( + id integer, + content text +); +INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS.'); +INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine.'); +INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga.'); +CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); +SET enable_seqscan = off; +SET enable_indexscan = off; +SET enable_bitmapscan = on; +SELECT id, content + FROM memos + WHERE content @~ 'groonga'; + id | content +----+------------------------------------------------------- + 2 | Groonga is fast full text search engine. + 3 | PGroonga is a PostgreSQL extension that uses Groonga. +(2 rows) + +DROP TABLE memos; </pre> </td> </tr> </tbody> </table> <table style="border-collapse: collapse; border: 1px solid #aaa"> <thead> <tr class="diff-header" style="border: 1px solid #aaa"> <td colspan="3"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"> Added: expected/regexp/text/partial/indexscan.out (+21 -0) 100644 =================================================================== </pre> </td> </tr> </thead> <tbody> <tr> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-49b2007e2591e095ca195c18524be214">...</a>                                           </pre> </th> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-49b2007e2591e095ca195c18524be214">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-49b2007e2591e095ca195c18524be214R1">1</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-49b2007e2591e095ca195c18524be214R2">2</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-49b2007e2591e095ca195c18524be214R3">3</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-49b2007e2591e095ca195c18524be214R4">4</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-49b2007e2591e095ca195c18524be214R5">5</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-49b2007e2591e095ca195c18524be214R6">6</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-49b2007e2591e095ca195c18524be214R7">7</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-49b2007e2591e095ca195c18524be214R8">8</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-49b2007e2591e095ca195c18524be214R9">9</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-49b2007e2591e095ca195c18524be214R10">10</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-49b2007e2591e095ca195c18524be214R11">11</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-49b2007e2591e095ca195c18524be214R12">12</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-49b2007e2591e095ca195c18524be214R13">13</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-49b2007e2591e095ca195c18524be214R14">14</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-49b2007e2591e095ca195c18524be214R15">15</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-49b2007e2591e095ca195c18524be214R16">16</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-49b2007e2591e095ca195c18524be214R17">17</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-49b2007e2591e095ca195c18524be214R18">18</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-49b2007e2591e095ca195c18524be214R19">19</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-49b2007e2591e095ca195c18524be214R20">20</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-49b2007e2591e095ca195c18524be214R21">21</a> </pre> </th> <td class="diff-content" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto">@@ -0,0 +1,21 @@ +CREATE TABLE memos ( + id integer, + content text +); +INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS.'); +INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine.'); +INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga.'); +CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); +SET enable_seqscan = off; +SET enable_indexscan = on; +SET enable_bitmapscan = off; +SELECT id, content + FROM memos + WHERE content @~ 'groonga'; + id | content +----+------------------------------------------------------- + 2 | Groonga is fast full text search engine. + 3 | PGroonga is a PostgreSQL extension that uses Groonga. +(2 rows) + +DROP TABLE memos; </pre> </td> </tr> </tbody> </table> <table style="border-collapse: collapse; border: 1px solid #aaa"> <thead> <tr class="diff-header" style="border: 1px solid #aaa"> <td colspan="3"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"> Added: expected/regexp/text/partial/seqscan.out (+21 -0) 100644 =================================================================== </pre> </td> </tr> </thead> <tbody> <tr> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-d707d2287c0429a83717c242b24fd46e">...</a>                                           </pre> </th> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-d707d2287c0429a83717c242b24fd46e">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-d707d2287c0429a83717c242b24fd46eR1">1</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-d707d2287c0429a83717c242b24fd46eR2">2</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-d707d2287c0429a83717c242b24fd46eR3">3</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-d707d2287c0429a83717c242b24fd46eR4">4</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-d707d2287c0429a83717c242b24fd46eR5">5</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-d707d2287c0429a83717c242b24fd46eR6">6</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-d707d2287c0429a83717c242b24fd46eR7">7</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-d707d2287c0429a83717c242b24fd46eR8">8</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-d707d2287c0429a83717c242b24fd46eR9">9</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-d707d2287c0429a83717c242b24fd46eR10">10</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-d707d2287c0429a83717c242b24fd46eR11">11</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-d707d2287c0429a83717c242b24fd46eR12">12</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-d707d2287c0429a83717c242b24fd46eR13">13</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-d707d2287c0429a83717c242b24fd46eR14">14</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-d707d2287c0429a83717c242b24fd46eR15">15</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-d707d2287c0429a83717c242b24fd46eR16">16</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-d707d2287c0429a83717c242b24fd46eR17">17</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-d707d2287c0429a83717c242b24fd46eR18">18</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-d707d2287c0429a83717c242b24fd46eR19">19</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-d707d2287c0429a83717c242b24fd46eR20">20</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-d707d2287c0429a83717c242b24fd46eR21">21</a> </pre> </th> <td class="diff-content" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto">@@ -0,0 +1,21 @@ +CREATE TABLE memos ( + id integer, + content text +); +INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS.'); +INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine.'); +INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga.'); +CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); +SET enable_seqscan = on; +SET enable_indexscan = off; +SET enable_bitmapscan = off; +SELECT id, content + FROM memos + WHERE content @~ 'groonga'; + id | content +----+------------------------------------------------------- + 2 | Groonga is fast full text search engine. + 3 | PGroonga is a PostgreSQL extension that uses Groonga. +(2 rows) + +DROP TABLE memos; </pre> </td> </tr> </tbody> </table> <table style="border-collapse: collapse; border: 1px solid #aaa"> <thead> <tr class="diff-header" style="border: 1px solid #aaa"> <td colspan="3"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"> Modified: pgroonga--0.9.0--1.0.0.sql (+39 -0) =================================================================== </pre> </td> </tr> </thead> <tbody> <tr> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-c360e0538b5244106e4378d0bd562c21">...</a>   <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-c360e0538b5244106e4378d0bd562c21L1">1</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-c360e0538b5244106e4378d0bd562c21L2">2</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-c360e0538b5244106e4378d0bd562c21L3">3</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-c360e0538b5244106e4378d0bd562c21L5">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-c360e0538b5244106e4378d0bd562c21L6">6</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-c360e0538b5244106e4378d0bd562c21L7">7</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-c360e0538b5244106e4378d0bd562c21L8">8</a>                                                                             </pre> </th> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-c360e0538b5244106e4378d0bd562c21">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-c360e0538b5244106e4378d0bd562c21R1">1</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-c360e0538b5244106e4378d0bd562c21R2">2</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-c360e0538b5244106e4378d0bd562c21R3">3</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-c360e0538b5244106e4378d0bd562c21R4">4</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-c360e0538b5244106e4378d0bd562c21R6">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-c360e0538b5244106e4378d0bd562c21R7">7</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-c360e0538b5244106e4378d0bd562c21R8">8</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-c360e0538b5244106e4378d0bd562c21R9">9</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-c360e0538b5244106e4378d0bd562c21R10">10</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-c360e0538b5244106e4378d0bd562c21R11">11</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-c360e0538b5244106e4378d0bd562c21R12">12</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-c360e0538b5244106e4378d0bd562c21R13">13</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-c360e0538b5244106e4378d0bd562c21R14">14</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-c360e0538b5244106e4378d0bd562c21R15">15</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-c360e0538b5244106e4378d0bd562c21R16">16</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-c360e0538b5244106e4378d0bd562c21R17">17</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-c360e0538b5244106e4378d0bd562c21R18">18</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-c360e0538b5244106e4378d0bd562c21R19">19</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-c360e0538b5244106e4378d0bd562c21R20">20</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-c360e0538b5244106e4378d0bd562c21R21">21</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-c360e0538b5244106e4378d0bd562c21R22">22</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-c360e0538b5244106e4378d0bd562c21R23">23</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-c360e0538b5244106e4378d0bd562c21R24">24</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-c360e0538b5244106e4378d0bd562c21R25">25</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-c360e0538b5244106e4378d0bd562c21R26">26</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-c360e0538b5244106e4378d0bd562c21R27">27</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-c360e0538b5244106e4378d0bd562c21R28">28</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-c360e0538b5244106e4378d0bd562c21R29">29</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-c360e0538b5244106e4378d0bd562c21R30">30</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-c360e0538b5244106e4378d0bd562c21R31">31</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-c360e0538b5244106e4378d0bd562c21R32">32</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-c360e0538b5244106e4378d0bd562c21R33">33</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-c360e0538b5244106e4378d0bd562c21R34">34</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-c360e0538b5244106e4378d0bd562c21R35">35</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-c360e0538b5244106e4378d0bd562c21R36">36</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-c360e0538b5244106e4378d0bd562c21R37">37</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-c360e0538b5244106e4378d0bd562c21R38">38</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-c360e0538b5244106e4378d0bd562c21R39">39</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-c360e0538b5244106e4378d0bd562c21R40">40</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-c360e0538b5244106e4378d0bd562c21R41">41</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-c360e0538b5244106e4378d0bd562c21R42">42</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-c360e0538b5244106e4378d0bd562c21R43">43</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-c360e0538b5244106e4378d0bd562c21R44">44</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-c360e0538b5244106e4378d0bd562c21R45">45</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-c360e0538b5244106e4378d0bd562c21R46">46</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-c360e0538b5244106e4378d0bd562c21R47">47</a> </pre> </th> <td class="diff-content" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto">@@ -1,3 +1,4 @@ +-- Support index only scan CREATE FUNCTION pgroonga.canreturn(internal) RETURNS internal AS 'MODULE_PATHNAME', 'pgroonga_canreturn' @@ -6,3 +7,41 @@ CREATE FUNCTION pgroonga.canreturn(internal) UPDATE pg_catalog.pg_am SET amcanreturn = 'pgroonga.canreturn' WHERE amname = 'pgroonga'; + + +-- Support @~ +UPDATE pg_catalog.pg_am SET amstrategies = 10 WHERE amname = 'pgroonga'; + +CREATE FUNCTION pgroonga.match_regexp(text, text) + RETURNS bool + AS 'MODULE_PATHNAME', 'pgroonga_match_regexp_text' + LANGUAGE C + IMMUTABLE + STRICT; + +CREATE FUNCTION pgroonga.match_regexp(varchar, varchar) + RETURNS bool + AS 'MODULE_PATHNAME', 'pgroonga_match_regexp_varchar' + LANGUAGE C + IMMUTABLE + STRICT; + +CREATE OPERATOR @~ ( + PROCEDURE = pgroonga.match_regexp, + LEFTARG = text, + RIGHTARG = text +); + +CREATE OPERATOR @~ ( + PROCEDURE = pgroonga.match_regexp, + LEFTARG = varchar, + RIGHTARG = varchar +); + +CREATE OPERATOR CLASS pgroonga.text_regexp_ops FOR TYPE text + USING pgroonga AS + OPERATOR 10 @~; + +CREATE OPERATOR CLASS pgroonga.varchar_regexp_ops FOR TYPE varchar + USING pgroonga AS + OPERATOR 10 @~; </pre> </td> </tr> </tbody> </table> <table style="border-collapse: collapse; border: 1px solid #aaa"> <thead> <tr class="diff-header" style="border: 1px solid #aaa"> <td colspan="3"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"> Modified: pgroonga.c (+89 -3) =================================================================== </pre> </td> </tr> </thead> <tbody> <tr> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L108">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L109">109</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L110">110</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L111">111</a>   <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L112">112</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L113">113</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L114">114</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L173">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L174">174</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L175">175</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L176">176</a>     <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L177">177</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L178">178</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L179">179</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L1196">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L1197">1197</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L1198">1198</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L1199">1199</a>                                 <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L1200">1200</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L1201">1201</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L1202">1202</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L1446">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L1447">1447</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L1448">1448</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L1449">1449</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L1450">1450</a>   <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L1451">1451</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L1452">1452</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L1453">1453</a>   <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L1454">1454</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L1455">1455</a>             <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L1456">1456</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L1457">1457</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L1458">1458</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L1472">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L1473">1473</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L1474">1474</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L1475">1475</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L1476">1476</a>   <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L1477">1477</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L1478">1478</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L1479">1479</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L1525">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L1526">1526</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L1527">1527</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L1528">1528</a>   <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L1529">1529</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L1530">1530</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L1531">1531</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L1533">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L1534">1534</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L1535">1535</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L1536">1536</a>   <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L1537">1537</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L1538">1538</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L1539">1539</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L2266">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L2267">2267</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L2268">2268</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L2269">2269</a>                                                                                                                 <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L2270">2270</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L2271">2271</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L2272">2272</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L3250">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L3251">3251</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L3252">3252</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L3253">3253</a>       <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L3254">3254</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L3255">3255</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49L3256">3256</a> </pre> </th> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R108">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R109">109</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R110">110</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R111">111</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R112">112</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R113">113</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R114">114</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R115">115</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R174">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R175">175</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R176">176</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R177">177</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R178">178</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R179">179</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R180">180</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R181">181</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R182">182</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1199">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1200">1200</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1201">1201</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1202">1202</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1203">1203</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1204">1204</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1205">1205</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1206">1206</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1207">1207</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1208">1208</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1209">1209</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1210">1210</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1211">1211</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1212">1212</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1213">1213</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1214">1214</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1215">1215</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1216">1216</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1217">1217</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1218">1218</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1219">1219</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1220">1220</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1221">1221</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1465">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1466">1466</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1467">1467</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1468">1468</a>   <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1469">1469</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1470">1470</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1471">1471</a>   <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1472">1472</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1473">1473</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1474">1474</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1475">1475</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1476">1476</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1477">1477</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1478">1478</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1479">1479</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1480">1480</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1481">1481</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1482">1482</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1483">1483</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1497">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1498">1498</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1499">1499</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1500">1500</a>   <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1501">1501</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1502">1502</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1503">1503</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1504">1504</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1550">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1551">1551</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1552">1552</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1553">1553</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1554">1554</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1555">1555</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1556">1556</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1557">1557</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1559">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1560">1560</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1561">1561</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1562">1562</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1563">1563</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1564">1564</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1565">1565</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R1566">1566</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2293">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2294">2294</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2295">2295</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2296">2296</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2297">2297</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2298">2298</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2299">2299</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2300">2300</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2301">2301</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2302">2302</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2303">2303</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2304">2304</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2305">2305</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2306">2306</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2307">2307</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2308">2308</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2309">2309</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2310">2310</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2311">2311</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2312">2312</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2313">2313</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2314">2314</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2315">2315</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2316">2316</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2317">2317</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2318">2318</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2319">2319</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2320">2320</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2321">2321</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2322">2322</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2323">2323</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2324">2324</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2325">2325</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2326">2326</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2327">2327</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2328">2328</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2329">2329</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2330">2330</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2331">2331</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2332">2332</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2333">2333</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2334">2334</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2335">2335</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2336">2336</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2337">2337</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2338">2338</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2339">2339</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2340">2340</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2341">2341</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2342">2342</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2343">2343</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2344">2344</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2345">2345</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2346">2346</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2347">2347</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2348">2348</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2349">2349</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2350">2350</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2351">2351</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2352">2352</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2353">2353</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2354">2354</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R2355">2355</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3333">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3334">3334</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3335">3335</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3336">3336</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3337">3337</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3338">3338</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3339">3339</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3340">3340</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3341">3341</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-a0b3c1b4fd7b5c53bf452181a6f32a49R3342">3342</a> </pre> </th> <td class="diff-content" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto">@@ -109,6 +109,7 @@ typedef struct PGrnCreateData TupleDesc desc; Oid relNode; bool forFullTextSearch; + bool forRegexpSearch; grn_id attributeTypeID; unsigned char attributeFlags; } PGrnCreateData; @@ -174,6 +175,8 @@ PG_FUNCTION_INFO_V1(pgroonga_contain_text_array); PG_FUNCTION_INFO_V1(pgroonga_contain_varchar); PG_FUNCTION_INFO_V1(pgroonga_contain_varchar_array); PG_FUNCTION_INFO_V1(pgroonga_match); +PG_FUNCTION_INFO_V1(pgroonga_match_regexp_text); +PG_FUNCTION_INFO_V1(pgroonga_match_regexp_varchar); PG_FUNCTION_INFO_V1(pgroonga_insert); PG_FUNCTION_INFO_V1(pgroonga_beginscan); @@ -1197,6 +1200,22 @@ PGrnIsForFullTextSearchIndex(Relation index, int nthAttribute) return OidIsValid(queryStrategyOID); } +static bool +PGrnIsForRegexpSearchIndex(Relation index, int nthAttribute) +{ + Oid regexpStrategyOID; + Oid leftType; + Oid rightType; + + leftType = index->rd_opcintype[nthAttribute]; + rightType = leftType; + regexpStrategyOID = get_opfamily_member(index->rd_opfamily[nthAttribute], + leftType, + rightType, + PGrnRegexpStrategyNumber); + return OidIsValid(regexpStrategyOID); +} + static void PGrnCreateSourcesCtidColumn(PGrnCreateData *data) { @@ -1447,12 +1466,18 @@ PGrnCreateIndexColumn(PGrnCreateData *data) grn_ctx_at(ctx, typeID)); GRN_PTR_PUT(ctx, data->lexicons, lexicon); - if (data->forFullTextSearch) + if (data->forFullTextSearch || data->forRegexpSearch) { PGrnOptions *options; - const char *tokenizerName = PGRN_DEFAULT_TOKENIZER; + const char *tokenizerName; const char *normalizerName = PGRN_DEFAULT_NORMALIZER; + if (data->forRegexpSearch) { + tokenizerName = "TokenRegexp"; + } else { + tokenizerName = PGRN_DEFAULT_TOKENIZER; + } + options = (PGrnOptions *) (data->index->rd_options); if (options) { @@ -1473,7 +1498,7 @@ PGrnCreateIndexColumn(PGrnCreateData *data) { grn_obj_flags flags = GRN_OBJ_COLUMN_INDEX; - if (data->forFullTextSearch) + if (data->forFullTextSearch || data->forRegexpSearch) flags |= GRN_OBJ_WITH_POSITION; PGrnCreateColumn(lexicon, PGrnIndexColumnName, @@ -1526,6 +1551,7 @@ PGrnCreate(Relation index, PGrnCreateDataColumnsForJSON(&data); PGrnCreateIndexColumnsForJSON(&data); data.forFullTextSearch = false; + data.forRegexpSearch = false; data.attributeTypeID = grn_obj_id(ctx, data.jsonValuesTable); data.attributeFlags = GRN_OBJ_VECTOR; PGrnCreateDataColumn(&data); @@ -1534,6 +1560,7 @@ PGrnCreate(Relation index, #endif { data.forFullTextSearch = PGrnIsForFullTextSearchIndex(index, data.i); + data.forRegexpSearch = PGrnIsForRegexpSearchIndex(index, data.i); data.attributeTypeID = PGrnGetType(index, data.i, &(data.attributeFlags)); PGrnCreateDataColumn(&data); @@ -2267,6 +2294,62 @@ pgroonga_match_jsonb(PG_FUNCTION_ARGS) PG_RETURN_BOOL(false); } +static grn_bool +pgroonga_match_regexp_raw(const char *text, unsigned int textSize, + const char *pattern, unsigned int patternSize) +{ + grn_bool matched; + grn_obj targetBuffer; + grn_obj patternBuffer; + + GRN_TEXT_INIT(&targetBuffer, GRN_OBJ_DO_SHALLOW_COPY); + GRN_TEXT_SET(ctx, &targetBuffer, text, textSize); + + GRN_TEXT_INIT(&patternBuffer, GRN_OBJ_DO_SHALLOW_COPY); + GRN_TEXT_SET(ctx, &patternBuffer, pattern, patternSize); + + matched = grn_operator_exec_regexp(ctx, &targetBuffer, &patternBuffer); + + GRN_OBJ_FIN(ctx, &targetBuffer); + GRN_OBJ_FIN(ctx, &patternBuffer); + + return matched; +} + +/** + * pgroonga.match_regexp_text(target, pattern) : bool + */ +Datum +pgroonga_match_regexp_text(PG_FUNCTION_ARGS) +{ + text *target = PG_GETARG_TEXT_PP(0); + text *pattern = PG_GETARG_TEXT_PP(1); + grn_bool matched; + + matched = pgroonga_match_regexp_raw(VARDATA_ANY(target), + VARSIZE_ANY_EXHDR(target), + VARDATA_ANY(pattern), + VARSIZE_ANY_EXHDR(pattern)); + PG_RETURN_BOOL(matched); +} + +/** + * pgroonga.match_regexp_varchar(target, pattern) : bool + */ +Datum +pgroonga_match_regexp_varchar(PG_FUNCTION_ARGS) +{ + VarChar *target = PG_GETARG_VARCHAR_PP(0); + VarChar *pattern = PG_GETARG_VARCHAR_PP(1); + grn_bool matched; + + matched = pgroonga_match_regexp_raw(VARDATA_ANY(target), + VARSIZE_ANY_EXHDR(target), + VARDATA_ANY(pattern), + VARSIZE_ANY_EXHDR(pattern)); + PG_RETURN_BOOL(matched); +} + #ifdef JSONBOID typedef struct PGrnInsertJSONData { @@ -3251,6 +3334,9 @@ PGrnSearchBuildCondition(IndexScanDesc scan, break; case PGrnQueryStrategyNumber: break; + case PGrnRegexpStrategyNumber: + operator = GRN_OP_REGEXP; + break; default: ereport(ERROR, (errcode(ERRCODE_INVALID_PARAMETER_VALUE), </pre> </td> </tr> </tbody> </table> <table style="border-collapse: collapse; border: 1px solid #aaa"> <thead> <tr class="diff-header" style="border: 1px solid #aaa"> <td colspan="3"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"> Modified: pgroonga.h (+1 -0) =================================================================== </pre> </td> </tr> </thead> <tbody> <tr> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-32975b580c6e9ac93875f68732469121L21">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-32975b580c6e9ac93875f68732469121L22">22</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-32975b580c6e9ac93875f68732469121L23">23</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-32975b580c6e9ac93875f68732469121L24">24</a>   <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-32975b580c6e9ac93875f68732469121L25">25</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-32975b580c6e9ac93875f68732469121L26">26</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-32975b580c6e9ac93875f68732469121L27">27</a> </pre> </th> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-32975b580c6e9ac93875f68732469121R21">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-32975b580c6e9ac93875f68732469121R22">22</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-32975b580c6e9ac93875f68732469121R23">23</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-32975b580c6e9ac93875f68732469121R24">24</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-32975b580c6e9ac93875f68732469121R25">25</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-32975b580c6e9ac93875f68732469121R26">26</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-32975b580c6e9ac93875f68732469121R27">27</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-32975b580c6e9ac93875f68732469121R28">28</a> </pre> </th> <td class="diff-content" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto">@@ -22,6 +22,7 @@ #define PGrnContainStrategyNumber 7 /* operator %% (@ in Groonga) */ #define PGrnQueryStrategyNumber 8 /* operator @@ (Groonga query) */ #define PGrnJSONContainStrategyNumber 9 /* operator @> */ +#define PGrnRegexpStrategyNumber 10 /* operator @~ (@~ in Groonga) */ /* file and table names */ #define PGrnLogBasename "pgroonga.log" </pre> </td> </tr> </tbody> </table> <table style="border-collapse: collapse; border: 1px solid #aaa"> <thead> <tr class="diff-header" style="border: 1px solid #aaa"> <td colspan="3"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"> Modified: pgroonga.sql (+36 -1) =================================================================== </pre> </td> </tr> </thead> <tbody> <tr> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773L122">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773L123">123</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773L124">124</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773L125">125</a>                                                       <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773L126">126</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773L127">127</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773L128">128</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773L178">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773L179">179</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773L180">180</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773L181">181</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773L182">182</a>   <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773L183">183</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773L184">184</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773L185">185</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773L333">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773L334">334</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773L335">335</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773L336">336</a>                 </pre> </th> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773R122">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773R123">123</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773R124">124</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773R125">125</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773R126">126</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773R127">127</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773R128">128</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773R129">129</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773R130">130</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773R131">131</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773R132">132</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773R133">133</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773R134">134</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773R135">135</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773R136">136</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773R137">137</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773R138">138</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773R139">139</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773R140">140</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773R141">141</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773R142">142</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773R143">143</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773R144">144</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773R145">145</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773R146">146</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773R147">147</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773R148">148</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773R149">149</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773R150">150</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773R151">151</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773R152">152</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773R153">153</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773R154">154</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773R155">155</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773R205">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773R206">206</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773R207">207</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773R208">208</a>   <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773R209">209</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773R210">210</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773R211">211</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773R212">212</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773R360">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773R361">361</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773R362">362</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773R363">363</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773R364">364</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773R365">365</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773R366">366</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773R367">367</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773R368">368</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773R369">369</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773R370">370</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-880e4f74ffc33862c9dcd6c9b4197773R371">371</a> </pre> </th> <td class="diff-content" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto">@@ -123,6 +123,33 @@ CREATE OPERATOR @@ ( ); +CREATE FUNCTION pgroonga.match_regexp(text, text) + RETURNS bool + AS 'MODULE_PATHNAME', 'pgroonga_match_regexp_text' + LANGUAGE C + IMMUTABLE + STRICT; + +CREATE FUNCTION pgroonga.match_regexp(varchar, varchar) + RETURNS bool + AS 'MODULE_PATHNAME', 'pgroonga_match_regexp_varchar' + LANGUAGE C + IMMUTABLE + STRICT; + +CREATE OPERATOR @~ ( + PROCEDURE = pgroonga.match_regexp, + LEFTARG = text, + RIGHTARG = text +); + +CREATE OPERATOR @~ ( + PROCEDURE = pgroonga.match_regexp, + LEFTARG = varchar, + RIGHTARG = varchar +); + + CREATE FUNCTION pgroonga.insert(internal) RETURNS bool AS 'MODULE_PATHNAME', 'pgroonga_insert' @@ -179,7 +206,7 @@ CREATE FUNCTION pgroonga.options(internal) DELETE FROM pg_catalog.pg_am WHERE amname = 'pgroonga'; INSERT INTO pg_catalog.pg_am VALUES( 'pgroonga', -- amname - 9, -- amstrategies + 10, -- amstrategies 0, -- amsupport true, -- amcanorder true, -- amcanorderbyop @@ -334,3 +361,11 @@ BEGIN END IF; END; $$; + +CREATE OPERATOR CLASS pgroonga.text_regexp_ops FOR TYPE text + USING pgroonga AS + OPERATOR 10 @~; + +CREATE OPERATOR CLASS pgroonga.varchar_regexp_ops FOR TYPE varchar + USING pgroonga AS + OPERATOR 10 @~; </pre> </td> </tr> </tbody> </table> <table style="border-collapse: collapse; border: 1px solid #aaa"> <thead> <tr class="diff-header" style="border: 1px solid #aaa"> <td colspan="3"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"> Added: sql/regexp/text/begin-of-text/bitmapscan.sql (+20 -0) 100644 =================================================================== </pre> </td> </tr> </thead> <tbody> <tr> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-5195066c0f7a9e4be4462492a980f84c">...</a>                                         </pre> </th> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-5195066c0f7a9e4be4462492a980f84c">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-5195066c0f7a9e4be4462492a980f84cR1">1</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-5195066c0f7a9e4be4462492a980f84cR2">2</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-5195066c0f7a9e4be4462492a980f84cR3">3</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-5195066c0f7a9e4be4462492a980f84cR4">4</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-5195066c0f7a9e4be4462492a980f84cR5">5</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-5195066c0f7a9e4be4462492a980f84cR6">6</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-5195066c0f7a9e4be4462492a980f84cR7">7</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-5195066c0f7a9e4be4462492a980f84cR8">8</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-5195066c0f7a9e4be4462492a980f84cR9">9</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-5195066c0f7a9e4be4462492a980f84cR10">10</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-5195066c0f7a9e4be4462492a980f84cR11">11</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-5195066c0f7a9e4be4462492a980f84cR12">12</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-5195066c0f7a9e4be4462492a980f84cR13">13</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-5195066c0f7a9e4be4462492a980f84cR14">14</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-5195066c0f7a9e4be4462492a980f84cR15">15</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-5195066c0f7a9e4be4462492a980f84cR16">16</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-5195066c0f7a9e4be4462492a980f84cR17">17</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-5195066c0f7a9e4be4462492a980f84cR18">18</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-5195066c0f7a9e4be4462492a980f84cR19">19</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-5195066c0f7a9e4be4462492a980f84cR20">20</a> </pre> </th> <td class="diff-content" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto">@@ -0,0 +1,20 @@ +CREATE TABLE memos ( + id integer, + content text +); + +INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS.'); +INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine.'); +INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga.'); + +CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); + +SET enable_seqscan = off; +SET enable_indexscan = off; +SET enable_bitmapscan = on; + +SELECT id, content + FROM memos + WHERE content @~ '\Agroonga'; + +DROP TABLE memos; </pre> </td> </tr> </tbody> </table> <table style="border-collapse: collapse; border: 1px solid #aaa"> <thead> <tr class="diff-header" style="border: 1px solid #aaa"> <td colspan="3"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"> Added: sql/regexp/text/begin-of-text/indexscan.sql (+20 -0) 100644 =================================================================== </pre> </td> </tr> </thead> <tbody> <tr> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-40c61eac600f3e7a527dc3a3e7ccba10">...</a>                                         </pre> </th> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-40c61eac600f3e7a527dc3a3e7ccba10">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-40c61eac600f3e7a527dc3a3e7ccba10R1">1</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-40c61eac600f3e7a527dc3a3e7ccba10R2">2</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-40c61eac600f3e7a527dc3a3e7ccba10R3">3</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-40c61eac600f3e7a527dc3a3e7ccba10R4">4</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-40c61eac600f3e7a527dc3a3e7ccba10R5">5</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-40c61eac600f3e7a527dc3a3e7ccba10R6">6</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-40c61eac600f3e7a527dc3a3e7ccba10R7">7</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-40c61eac600f3e7a527dc3a3e7ccba10R8">8</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-40c61eac600f3e7a527dc3a3e7ccba10R9">9</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-40c61eac600f3e7a527dc3a3e7ccba10R10">10</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-40c61eac600f3e7a527dc3a3e7ccba10R11">11</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-40c61eac600f3e7a527dc3a3e7ccba10R12">12</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-40c61eac600f3e7a527dc3a3e7ccba10R13">13</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-40c61eac600f3e7a527dc3a3e7ccba10R14">14</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-40c61eac600f3e7a527dc3a3e7ccba10R15">15</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-40c61eac600f3e7a527dc3a3e7ccba10R16">16</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-40c61eac600f3e7a527dc3a3e7ccba10R17">17</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-40c61eac600f3e7a527dc3a3e7ccba10R18">18</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-40c61eac600f3e7a527dc3a3e7ccba10R19">19</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-40c61eac600f3e7a527dc3a3e7ccba10R20">20</a> </pre> </th> <td class="diff-content" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto">@@ -0,0 +1,20 @@ +CREATE TABLE memos ( + id integer, + content text +); + +INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS.'); +INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine.'); +INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga.'); + +CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); + +SET enable_seqscan = off; +SET enable_indexscan = on; +SET enable_bitmapscan = off; + +SELECT id, content + FROM memos + WHERE content @~ '\Agroonga'; + +DROP TABLE memos; </pre> </td> </tr> </tbody> </table> <table style="border-collapse: collapse; border: 1px solid #aaa"> <thead> <tr class="diff-header" style="border: 1px solid #aaa"> <td colspan="3"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"> Added: sql/regexp/text/begin-of-text/seqscan.sql (+20 -0) 100644 =================================================================== </pre> </td> </tr> </thead> <tbody> <tr> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-3312747c297cb0084642132fb1f495c5">...</a>                                         </pre> </th> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-3312747c297cb0084642132fb1f495c5">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-3312747c297cb0084642132fb1f495c5R1">1</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-3312747c297cb0084642132fb1f495c5R2">2</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-3312747c297cb0084642132fb1f495c5R3">3</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-3312747c297cb0084642132fb1f495c5R4">4</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-3312747c297cb0084642132fb1f495c5R5">5</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-3312747c297cb0084642132fb1f495c5R6">6</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-3312747c297cb0084642132fb1f495c5R7">7</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-3312747c297cb0084642132fb1f495c5R8">8</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-3312747c297cb0084642132fb1f495c5R9">9</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-3312747c297cb0084642132fb1f495c5R10">10</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-3312747c297cb0084642132fb1f495c5R11">11</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-3312747c297cb0084642132fb1f495c5R12">12</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-3312747c297cb0084642132fb1f495c5R13">13</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-3312747c297cb0084642132fb1f495c5R14">14</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-3312747c297cb0084642132fb1f495c5R15">15</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-3312747c297cb0084642132fb1f495c5R16">16</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-3312747c297cb0084642132fb1f495c5R17">17</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-3312747c297cb0084642132fb1f495c5R18">18</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-3312747c297cb0084642132fb1f495c5R19">19</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-3312747c297cb0084642132fb1f495c5R20">20</a> </pre> </th> <td class="diff-content" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto">@@ -0,0 +1,20 @@ +CREATE TABLE memos ( + id integer, + content text +); + +INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS.'); +INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine.'); +INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga.'); + +CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); + +SET enable_seqscan = on; +SET enable_indexscan = off; +SET enable_bitmapscan = off; + +SELECT id, content + FROM memos + WHERE content @~ '\Agroonga'; + +DROP TABLE memos; </pre> </td> </tr> </tbody> </table> <table style="border-collapse: collapse; border: 1px solid #aaa"> <thead> <tr class="diff-header" style="border: 1px solid #aaa"> <td colspan="3"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"> Added: sql/regexp/text/end-of-text/bitmapscan.sql (+20 -0) 100644 =================================================================== </pre> </td> </tr> </thead> <tbody> <tr> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-174143402ca4159476741b9624128c0c">...</a>                                         </pre> </th> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-174143402ca4159476741b9624128c0c">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-174143402ca4159476741b9624128c0cR1">1</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-174143402ca4159476741b9624128c0cR2">2</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-174143402ca4159476741b9624128c0cR3">3</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-174143402ca4159476741b9624128c0cR4">4</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-174143402ca4159476741b9624128c0cR5">5</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-174143402ca4159476741b9624128c0cR6">6</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-174143402ca4159476741b9624128c0cR7">7</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-174143402ca4159476741b9624128c0cR8">8</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-174143402ca4159476741b9624128c0cR9">9</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-174143402ca4159476741b9624128c0cR10">10</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-174143402ca4159476741b9624128c0cR11">11</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-174143402ca4159476741b9624128c0cR12">12</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-174143402ca4159476741b9624128c0cR13">13</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-174143402ca4159476741b9624128c0cR14">14</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-174143402ca4159476741b9624128c0cR15">15</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-174143402ca4159476741b9624128c0cR16">16</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-174143402ca4159476741b9624128c0cR17">17</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-174143402ca4159476741b9624128c0cR18">18</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-174143402ca4159476741b9624128c0cR19">19</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-174143402ca4159476741b9624128c0cR20">20</a> </pre> </th> <td class="diff-content" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto">@@ -0,0 +1,20 @@ +CREATE TABLE memos ( + id integer, + content text +); + +INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS'); +INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine'); +INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga'); + +CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); + +SET enable_seqscan = off; +SET enable_indexscan = off; +SET enable_bitmapscan = on; + +SELECT id, content + FROM memos + WHERE content @~ 'groonga\z'; + +DROP TABLE memos; </pre> </td> </tr> </tbody> </table> <table style="border-collapse: collapse; border: 1px solid #aaa"> <thead> <tr class="diff-header" style="border: 1px solid #aaa"> <td colspan="3"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"> Added: sql/regexp/text/end-of-text/indexscan.sql (+20 -0) 100644 =================================================================== </pre> </td> </tr> </thead> <tbody> <tr> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-33d37f33461911a353e8e02d03689356">...</a>                                         </pre> </th> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-33d37f33461911a353e8e02d03689356">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-33d37f33461911a353e8e02d03689356R1">1</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-33d37f33461911a353e8e02d03689356R2">2</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-33d37f33461911a353e8e02d03689356R3">3</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-33d37f33461911a353e8e02d03689356R4">4</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-33d37f33461911a353e8e02d03689356R5">5</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-33d37f33461911a353e8e02d03689356R6">6</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-33d37f33461911a353e8e02d03689356R7">7</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-33d37f33461911a353e8e02d03689356R8">8</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-33d37f33461911a353e8e02d03689356R9">9</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-33d37f33461911a353e8e02d03689356R10">10</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-33d37f33461911a353e8e02d03689356R11">11</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-33d37f33461911a353e8e02d03689356R12">12</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-33d37f33461911a353e8e02d03689356R13">13</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-33d37f33461911a353e8e02d03689356R14">14</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-33d37f33461911a353e8e02d03689356R15">15</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-33d37f33461911a353e8e02d03689356R16">16</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-33d37f33461911a353e8e02d03689356R17">17</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-33d37f33461911a353e8e02d03689356R18">18</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-33d37f33461911a353e8e02d03689356R19">19</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-33d37f33461911a353e8e02d03689356R20">20</a> </pre> </th> <td class="diff-content" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto">@@ -0,0 +1,20 @@ +CREATE TABLE memos ( + id integer, + content text +); + +INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS'); +INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine'); +INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga'); + +CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); + +SET enable_seqscan = off; +SET enable_indexscan = on; +SET enable_bitmapscan = off; + +SELECT id, content + FROM memos + WHERE content @~ 'groonga\z'; + +DROP TABLE memos; </pre> </td> </tr> </tbody> </table> <table style="border-collapse: collapse; border: 1px solid #aaa"> <thead> <tr class="diff-header" style="border: 1px solid #aaa"> <td colspan="3"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"> Added: sql/regexp/text/end-of-text/seqscan.sql (+20 -0) 100644 =================================================================== </pre> </td> </tr> </thead> <tbody> <tr> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-066d88d6922a09290177a18f782bab88">...</a>                                         </pre> </th> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-066d88d6922a09290177a18f782bab88">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-066d88d6922a09290177a18f782bab88R1">1</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-066d88d6922a09290177a18f782bab88R2">2</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-066d88d6922a09290177a18f782bab88R3">3</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-066d88d6922a09290177a18f782bab88R4">4</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-066d88d6922a09290177a18f782bab88R5">5</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-066d88d6922a09290177a18f782bab88R6">6</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-066d88d6922a09290177a18f782bab88R7">7</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-066d88d6922a09290177a18f782bab88R8">8</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-066d88d6922a09290177a18f782bab88R9">9</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-066d88d6922a09290177a18f782bab88R10">10</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-066d88d6922a09290177a18f782bab88R11">11</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-066d88d6922a09290177a18f782bab88R12">12</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-066d88d6922a09290177a18f782bab88R13">13</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-066d88d6922a09290177a18f782bab88R14">14</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-066d88d6922a09290177a18f782bab88R15">15</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-066d88d6922a09290177a18f782bab88R16">16</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-066d88d6922a09290177a18f782bab88R17">17</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-066d88d6922a09290177a18f782bab88R18">18</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-066d88d6922a09290177a18f782bab88R19">19</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-066d88d6922a09290177a18f782bab88R20">20</a> </pre> </th> <td class="diff-content" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto">@@ -0,0 +1,20 @@ +CREATE TABLE memos ( + id integer, + content text +); + +INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS'); +INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine'); +INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga'); + +CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); + +SET enable_seqscan = on; +SET enable_indexscan = off; +SET enable_bitmapscan = off; + +SELECT id, content + FROM memos + WHERE content @~ 'groonga\z'; + +DROP TABLE memos; </pre> </td> </tr> </tbody> </table> <table style="border-collapse: collapse; border: 1px solid #aaa"> <thead> <tr class="diff-header" style="border: 1px solid #aaa"> <td colspan="3"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"> Added: sql/regexp/text/exact/bitmapscan.sql (+20 -0) 100644 =================================================================== </pre> </td> </tr> </thead> <tbody> <tr> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-b5c5028a44dc56826ca4242cc15309ea">...</a>                                         </pre> </th> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-b5c5028a44dc56826ca4242cc15309ea">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-b5c5028a44dc56826ca4242cc15309eaR1">1</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-b5c5028a44dc56826ca4242cc15309eaR2">2</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-b5c5028a44dc56826ca4242cc15309eaR3">3</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-b5c5028a44dc56826ca4242cc15309eaR4">4</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-b5c5028a44dc56826ca4242cc15309eaR5">5</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-b5c5028a44dc56826ca4242cc15309eaR6">6</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-b5c5028a44dc56826ca4242cc15309eaR7">7</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-b5c5028a44dc56826ca4242cc15309eaR8">8</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-b5c5028a44dc56826ca4242cc15309eaR9">9</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-b5c5028a44dc56826ca4242cc15309eaR10">10</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-b5c5028a44dc56826ca4242cc15309eaR11">11</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-b5c5028a44dc56826ca4242cc15309eaR12">12</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-b5c5028a44dc56826ca4242cc15309eaR13">13</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-b5c5028a44dc56826ca4242cc15309eaR14">14</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-b5c5028a44dc56826ca4242cc15309eaR15">15</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-b5c5028a44dc56826ca4242cc15309eaR16">16</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-b5c5028a44dc56826ca4242cc15309eaR17">17</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-b5c5028a44dc56826ca4242cc15309eaR18">18</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-b5c5028a44dc56826ca4242cc15309eaR19">19</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-b5c5028a44dc56826ca4242cc15309eaR20">20</a> </pre> </th> <td class="diff-content" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto">@@ -0,0 +1,20 @@ +CREATE TABLE memos ( + id integer, + content text +); + +INSERT INTO memos VALUES (1, 'PostgreSQL'); +INSERT INTO memos VALUES (2, 'Groonga'); +INSERT INTO memos VALUES (3, 'PGroonga'); + +CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); + +SET enable_seqscan = off; +SET enable_indexscan = off; +SET enable_bitmapscan = on; + +SELECT id, content + FROM memos + WHERE content @~ '\Agroonga\z'; + +DROP TABLE memos; </pre> </td> </tr> </tbody> </table> <table style="border-collapse: collapse; border: 1px solid #aaa"> <thead> <tr class="diff-header" style="border: 1px solid #aaa"> <td colspan="3"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"> Added: sql/regexp/text/exact/indexscan.sql (+20 -0) 100644 =================================================================== </pre> </td> </tr> </thead> <tbody> <tr> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-349f855144d7f14cbfe9e814d9137b5a">...</a>                                         </pre> </th> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-349f855144d7f14cbfe9e814d9137b5a">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-349f855144d7f14cbfe9e814d9137b5aR1">1</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-349f855144d7f14cbfe9e814d9137b5aR2">2</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-349f855144d7f14cbfe9e814d9137b5aR3">3</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-349f855144d7f14cbfe9e814d9137b5aR4">4</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-349f855144d7f14cbfe9e814d9137b5aR5">5</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-349f855144d7f14cbfe9e814d9137b5aR6">6</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-349f855144d7f14cbfe9e814d9137b5aR7">7</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-349f855144d7f14cbfe9e814d9137b5aR8">8</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-349f855144d7f14cbfe9e814d9137b5aR9">9</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-349f855144d7f14cbfe9e814d9137b5aR10">10</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-349f855144d7f14cbfe9e814d9137b5aR11">11</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-349f855144d7f14cbfe9e814d9137b5aR12">12</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-349f855144d7f14cbfe9e814d9137b5aR13">13</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-349f855144d7f14cbfe9e814d9137b5aR14">14</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-349f855144d7f14cbfe9e814d9137b5aR15">15</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-349f855144d7f14cbfe9e814d9137b5aR16">16</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-349f855144d7f14cbfe9e814d9137b5aR17">17</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-349f855144d7f14cbfe9e814d9137b5aR18">18</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-349f855144d7f14cbfe9e814d9137b5aR19">19</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-349f855144d7f14cbfe9e814d9137b5aR20">20</a> </pre> </th> <td class="diff-content" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto">@@ -0,0 +1,20 @@ +CREATE TABLE memos ( + id integer, + content text +); + +INSERT INTO memos VALUES (1, 'PostgreSQL'); +INSERT INTO memos VALUES (2, 'Groonga'); +INSERT INTO memos VALUES (3, 'PGroonga'); + +CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); + +SET enable_seqscan = off; +SET enable_indexscan = on; +SET enable_bitmapscan = off; + +SELECT id, content + FROM memos + WHERE content @~ '\Agroonga\z'; + +DROP TABLE memos; </pre> </td> </tr> </tbody> </table> <table style="border-collapse: collapse; border: 1px solid #aaa"> <thead> <tr class="diff-header" style="border: 1px solid #aaa"> <td colspan="3"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"> Added: sql/regexp/text/exact/seqscan.sql (+20 -0) 100644 =================================================================== </pre> </td> </tr> </thead> <tbody> <tr> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-2cc93289c5b5d6f3a9f6b3e303ba9a0f">...</a>                                         </pre> </th> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-2cc93289c5b5d6f3a9f6b3e303ba9a0f">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-2cc93289c5b5d6f3a9f6b3e303ba9a0fR1">1</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-2cc93289c5b5d6f3a9f6b3e303ba9a0fR2">2</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-2cc93289c5b5d6f3a9f6b3e303ba9a0fR3">3</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-2cc93289c5b5d6f3a9f6b3e303ba9a0fR4">4</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-2cc93289c5b5d6f3a9f6b3e303ba9a0fR5">5</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-2cc93289c5b5d6f3a9f6b3e303ba9a0fR6">6</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-2cc93289c5b5d6f3a9f6b3e303ba9a0fR7">7</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-2cc93289c5b5d6f3a9f6b3e303ba9a0fR8">8</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-2cc93289c5b5d6f3a9f6b3e303ba9a0fR9">9</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-2cc93289c5b5d6f3a9f6b3e303ba9a0fR10">10</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-2cc93289c5b5d6f3a9f6b3e303ba9a0fR11">11</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-2cc93289c5b5d6f3a9f6b3e303ba9a0fR12">12</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-2cc93289c5b5d6f3a9f6b3e303ba9a0fR13">13</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-2cc93289c5b5d6f3a9f6b3e303ba9a0fR14">14</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-2cc93289c5b5d6f3a9f6b3e303ba9a0fR15">15</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-2cc93289c5b5d6f3a9f6b3e303ba9a0fR16">16</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-2cc93289c5b5d6f3a9f6b3e303ba9a0fR17">17</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-2cc93289c5b5d6f3a9f6b3e303ba9a0fR18">18</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-2cc93289c5b5d6f3a9f6b3e303ba9a0fR19">19</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-2cc93289c5b5d6f3a9f6b3e303ba9a0fR20">20</a> </pre> </th> <td class="diff-content" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto">@@ -0,0 +1,20 @@ +CREATE TABLE memos ( + id integer, + content text +); + +INSERT INTO memos VALUES (1, 'PostgreSQL'); +INSERT INTO memos VALUES (2, 'Groonga'); +INSERT INTO memos VALUES (3, 'PGroonga'); + +CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); + +SET enable_seqscan = on; +SET enable_indexscan = off; +SET enable_bitmapscan = off; + +SELECT id, content + FROM memos + WHERE content @~ '\Agroonga\z'; + +DROP TABLE memos; </pre> </td> </tr> </tbody> </table> <table style="border-collapse: collapse; border: 1px solid #aaa"> <thead> <tr class="diff-header" style="border: 1px solid #aaa"> <td colspan="3"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"> Added: sql/regexp/text/partial/bitmapscan.sql (+20 -0) 100644 =================================================================== </pre> </td> </tr> </thead> <tbody> <tr> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-05190fdb1555dd79d40f0e8d44f1450e">...</a>                                         </pre> </th> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-05190fdb1555dd79d40f0e8d44f1450e">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-05190fdb1555dd79d40f0e8d44f1450eR1">1</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-05190fdb1555dd79d40f0e8d44f1450eR2">2</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-05190fdb1555dd79d40f0e8d44f1450eR3">3</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-05190fdb1555dd79d40f0e8d44f1450eR4">4</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-05190fdb1555dd79d40f0e8d44f1450eR5">5</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-05190fdb1555dd79d40f0e8d44f1450eR6">6</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-05190fdb1555dd79d40f0e8d44f1450eR7">7</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-05190fdb1555dd79d40f0e8d44f1450eR8">8</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-05190fdb1555dd79d40f0e8d44f1450eR9">9</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-05190fdb1555dd79d40f0e8d44f1450eR10">10</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-05190fdb1555dd79d40f0e8d44f1450eR11">11</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-05190fdb1555dd79d40f0e8d44f1450eR12">12</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-05190fdb1555dd79d40f0e8d44f1450eR13">13</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-05190fdb1555dd79d40f0e8d44f1450eR14">14</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-05190fdb1555dd79d40f0e8d44f1450eR15">15</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-05190fdb1555dd79d40f0e8d44f1450eR16">16</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-05190fdb1555dd79d40f0e8d44f1450eR17">17</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-05190fdb1555dd79d40f0e8d44f1450eR18">18</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-05190fdb1555dd79d40f0e8d44f1450eR19">19</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-05190fdb1555dd79d40f0e8d44f1450eR20">20</a> </pre> </th> <td class="diff-content" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto">@@ -0,0 +1,20 @@ +CREATE TABLE memos ( + id integer, + content text +); + +INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS.'); +INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine.'); +INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga.'); + +CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); + +SET enable_seqscan = off; +SET enable_indexscan = off; +SET enable_bitmapscan = on; + +SELECT id, content + FROM memos + WHERE content @~ 'groonga'; + +DROP TABLE memos; </pre> </td> </tr> </tbody> </table> <table style="border-collapse: collapse; border: 1px solid #aaa"> <thead> <tr class="diff-header" style="border: 1px solid #aaa"> <td colspan="3"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"> Added: sql/regexp/text/partial/indexscan.sql (+20 -0) 100644 =================================================================== </pre> </td> </tr> </thead> <tbody> <tr> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-54980abe4075aa0f6ed11f145a7fd5ef">...</a>                                         </pre> </th> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-54980abe4075aa0f6ed11f145a7fd5ef">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-54980abe4075aa0f6ed11f145a7fd5efR1">1</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-54980abe4075aa0f6ed11f145a7fd5efR2">2</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-54980abe4075aa0f6ed11f145a7fd5efR3">3</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-54980abe4075aa0f6ed11f145a7fd5efR4">4</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-54980abe4075aa0f6ed11f145a7fd5efR5">5</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-54980abe4075aa0f6ed11f145a7fd5efR6">6</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-54980abe4075aa0f6ed11f145a7fd5efR7">7</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-54980abe4075aa0f6ed11f145a7fd5efR8">8</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-54980abe4075aa0f6ed11f145a7fd5efR9">9</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-54980abe4075aa0f6ed11f145a7fd5efR10">10</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-54980abe4075aa0f6ed11f145a7fd5efR11">11</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-54980abe4075aa0f6ed11f145a7fd5efR12">12</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-54980abe4075aa0f6ed11f145a7fd5efR13">13</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-54980abe4075aa0f6ed11f145a7fd5efR14">14</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-54980abe4075aa0f6ed11f145a7fd5efR15">15</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-54980abe4075aa0f6ed11f145a7fd5efR16">16</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-54980abe4075aa0f6ed11f145a7fd5efR17">17</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-54980abe4075aa0f6ed11f145a7fd5efR18">18</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-54980abe4075aa0f6ed11f145a7fd5efR19">19</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-54980abe4075aa0f6ed11f145a7fd5efR20">20</a> </pre> </th> <td class="diff-content" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto">@@ -0,0 +1,20 @@ +CREATE TABLE memos ( + id integer, + content text +); + +INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS.'); +INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine.'); +INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga.'); + +CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); + +SET enable_seqscan = off; +SET enable_indexscan = on; +SET enable_bitmapscan = off; + +SELECT id, content + FROM memos + WHERE content @~ 'groonga'; + +DROP TABLE memos; </pre> </td> </tr> </tbody> </table> <table style="border-collapse: collapse; border: 1px solid #aaa"> <thead> <tr class="diff-header" style="border: 1px solid #aaa"> <td colspan="3"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"> Added: sql/regexp/text/partial/seqscan.sql (+20 -0) 100644 =================================================================== </pre> </td> </tr> </thead> <tbody> <tr> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-62c48661d6da6b991f305b6153fc3c7d">...</a>                                         </pre> </th> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-62c48661d6da6b991f305b6153fc3c7d">...</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-62c48661d6da6b991f305b6153fc3c7dR1">1</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-62c48661d6da6b991f305b6153fc3c7dR2">2</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-62c48661d6da6b991f305b6153fc3c7dR3">3</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-62c48661d6da6b991f305b6153fc3c7dR4">4</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-62c48661d6da6b991f305b6153fc3c7dR5">5</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-62c48661d6da6b991f305b6153fc3c7dR6">6</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-62c48661d6da6b991f305b6153fc3c7dR7">7</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-62c48661d6da6b991f305b6153fc3c7dR8">8</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-62c48661d6da6b991f305b6153fc3c7dR9">9</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-62c48661d6da6b991f305b6153fc3c7dR10">10</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-62c48661d6da6b991f305b6153fc3c7dR11">11</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-62c48661d6da6b991f305b6153fc3c7dR12">12</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-62c48661d6da6b991f305b6153fc3c7dR13">13</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-62c48661d6da6b991f305b6153fc3c7dR14">14</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-62c48661d6da6b991f305b6153fc3c7dR15">15</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-62c48661d6da6b991f305b6153fc3c7dR16">16</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-62c48661d6da6b991f305b6153fc3c7dR17">17</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-62c48661d6da6b991f305b6153fc3c7dR18">18</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-62c48661d6da6b991f305b6153fc3c7dR19">19</a> <a href="https://github.com/pgroonga/pgroonga/commit/d0b2d675e0a8c570a83484977bd7cf77fa8fc60a#diff-62c48661d6da6b991f305b6153fc3c7dR20">20</a> </pre> </th> <td class="diff-content" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto">@@ -0,0 +1,20 @@ +CREATE TABLE memos ( + id integer, + content text +); + +INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS.'); +INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine.'); +INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga.'); + +CREATE INDEX grnindex ON memos USING pgroonga (content pgroonga.text_regexp_ops); + +SET enable_seqscan = on; +SET enable_indexscan = off; +SET enable_bitmapscan = off; + +SELECT id, content + FROM memos + WHERE content @~ 'groonga'; + +DROP TABLE memos; </pre> </td> </tr> </tbody> </table> </div> </body> </html>