<!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-24 17:44:00 +0900 (Sat, 24 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.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b">a3048b049d6e8d97a664e39701d6f8f55f427c4b</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">Translate LIKE</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.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4b">_po/ja/reference/operators/like.po</a></li>
<li><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3">ja/reference/operators/like.md</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"><span class="diff-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre"> Added: _po/ja/reference/operators/like.po (+147 -0) 100644</span>
<span class="diff-header-mark" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">===================================================================</span>
</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"><span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4b">...</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
</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"><span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4b">...</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR1">1</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR2">2</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR3">3</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR4">4</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR5">5</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR6">6</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR7">7</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR8">8</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR9">9</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR10">10</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR11">11</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR12">12</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR13">13</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR14">14</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR15">15</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR16">16</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR17">17</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR18">18</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR19">19</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR20">20</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR21">21</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR22">22</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR23">23</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR24">24</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR25">25</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR26">26</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR27">27</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR28">28</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR29">29</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR30">30</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR31">31</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR32">32</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR33">33</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR34">34</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR35">35</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR36">36</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR37">37</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR38">38</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR39">39</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR40">40</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR41">41</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR42">42</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR43">43</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR44">44</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR45">45</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR46">46</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR47">47</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR48">48</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR49">49</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR50">50</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR51">51</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR52">52</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR53">53</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR54">54</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR55">55</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR56">56</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR57">57</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR58">58</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR59">59</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR60">60</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR61">61</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR62">62</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR63">63</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR64">64</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR65">65</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR66">66</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR67">67</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR68">68</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR69">69</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR70">70</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR71">71</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR72">72</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR73">73</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR74">74</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR75">75</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR76">76</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR77">77</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR78">78</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR79">79</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR80">80</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR81">81</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR82">82</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR83">83</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR84">84</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR85">85</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR86">86</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR87">87</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR88">88</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR89">89</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR90">90</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR91">91</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR92">92</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR93">93</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR94">94</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR95">95</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR96">96</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR97">97</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR98">98</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR99">99</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR100">100</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR101">101</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR102">102</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR103">103</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR104">104</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR105">105</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR106">106</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR107">107</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR108">108</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR109">109</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR110">110</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR111">111</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR112">112</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR113">113</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR114">114</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR115">115</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR116">116</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR117">117</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR118">118</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR119">119</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR120">120</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR121">121</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR122">122</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR123">123</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR124">124</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR125">125</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR126">126</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR127">127</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR128">128</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR129">129</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR130">130</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR131">131</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR132">132</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR133">133</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR134">134</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR135">135</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR136">136</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR137">137</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR138">138</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR139">139</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR140">140</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR141">141</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR142">142</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR143">143</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR144">144</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR145">145</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR146">146</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR147">147</a></span>
</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"><span class="diff-hunk-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">@@ -0,0 +1,147 @@</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+msgid ""</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+msgstr ""</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"Project-Id-Version: PACKAGE VERSION\n"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"PO-Revision-Date: 2015-10-24 17:43+0900\n"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"Language: ja\n"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"MIME-Version: 1.0\n"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"Content-Type: text/plain; charset=UTF-8\n"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"Content-Transfer-Encoding: 8bit\n"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"Plural-Forms: nplurals=1; plural=0;\n"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+msgid ""</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"---\n"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"title: LIKE operator\n"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"layout: en\n"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"---"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+msgstr ""</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"---\n"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"title: LIKE演算子\n"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"layout: ja\n"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"---"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+msgid "# `LIKE` operator"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+msgstr "# `LIKE`演算子"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+msgid ""</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"PGroonga converts `column LIKE '%KEYWORD%'` condition to `column %% 'KEYWORD'`"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+" internally. [`%%` operator](match.html) does full text search with index. It'"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"s fast rather than `LIKE` operator without index."</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+msgstr ""</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"PGroongaは内部的に`column LIKE '%キーワード%'`条件を`column %% 'キーワード'`条件に変換します。[`%%`演算子](m"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"atch.html)はインデックスを使って全文検索をします。これはインデックスを使わない`LIKE`演算子より速いです。"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+msgid ""</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"Both beginning `%` and ending `%` are important. `'KEYWORD%'`, `'%KEYWORD'` an"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"d so on aren't converted to `column %% 'KEYWORD'`. PGroonga returns no records"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+" for these patterns. Because PGroonga can't search these patterns with index."</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+msgstr ""</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"最初の`%`と最後の`%`はどちらも重要です。`'キーワード%'`、`'%キーワード'`などは`column %% 'キーワード'`に変換されます。このよう"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"なパターンを指定するとPGroongaは1件もレコードを返しません。なぜならPGroongaはインデックスなしではこれらのパターンを検索できないからです。"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+msgid ""</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"The original `LIKE` operator searches against text as is. But `%%` operator do"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"es full text search against normalized text. It means that search result of `L"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"IKE` operator with index and search result of the original `LIKE` operator may"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+" be different."</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+msgstr ""</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"元の`LIKE`演算子は対象テキストに対して検索します。しかし、`%%`演算子は正規化したテキストに対して検索します。これは、インデックスを使った`LIKE"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"`演算子の検索結果と、元の`LIKE`演算子の検索結果は異なるということです。"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+msgid ""</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"For example, the original `LIKE` operator searches with case sensitive. But `L"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"IKE` operator with index searches with case insensitive."</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+msgstr "たとえば、元の`LIKE`演算子は大文字小文字を区別して検索します。しかし、インデックスを使った`LIKE`演算子は大文字小文字を区別しません。"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+msgid "A search result of the original `LIKE` operator:"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+msgstr "元の`LIKE`演算子の結果です。"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+msgid ""</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"```sql\n"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"SET enable_seqscan = on;\n"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"SET enable_indexscan = off;\n"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"SET enable_bitmapscan = off;\n"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"SELECT * FROM memos WHERE content LIKE '%groonga%';\n"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"-- id | content \n"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"-- ----+-----------------------------\n"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"-- 4 | groongaコマンドがあります。\n"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"-- (1 行)\n"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"```"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+msgstr ""</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+msgid "A search result of `LIKE` operator with index:"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+msgstr "インデックスを使った`LIKE`演算子の結果です。"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+msgid ""</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"```sql\n"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"SET enable_seqscan = off;\n"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"SET enable_indexscan = on;\n"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"SET enable_bitmapscan = on;\n"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"SELECT * FROM memos WHERE content LIKE '%groonga%';\n"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"-- id | content "</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+" \n"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"-- ----+----------------------------------------------------------------------"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"-----\n"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"-- 2 | Groongaは日本語対応の高速な全文検索エンジンです。\n"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"-- 3 | PGroongaはインデックスとしてGroongaを使うためのPostgreSQLの拡張機能です。\n"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"-- 4 | groongaコマンドがあります。\n"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"-- (3 行)\n"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"```"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+msgstr ""</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+msgid ""</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"If you want to get the same result by both `LIKE` operator with index and the "</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"original `LIKE` operator, use the following tokenizer and normalizer:"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+msgstr "インデックスを使った`LIKE`演算子の結果と元の`LIKE`演算子の結果を同じにしたい場合は次のトークナイザーとノーマライザーを使います。"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+msgid ""</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+" * Tokenizer: `TokenBigramSplitSymbolAlphaDigit`\n"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+" * Normalizer: None"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+msgstr ""</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+" * トークナイザー: `TokenBigramSplitSymbolAlphaDigit`\n"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+" * ノーマライザー: なし"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+msgid "Here is a concrete example:"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+msgstr "具体例は次の通りです。"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+msgid ""</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"```sql\n"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"CREATE INDEX pgroonga_content_index\n"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+" ON memos\n"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+" USING pgroonga (content)\n"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+" WITH (tokenizer='TokenBigramSplitSymbolAlphaDigit',\n"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+" normalizer='');\n"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"```"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+msgstr ""</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+msgid ""</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"You can get the same result as the original `LIKE` operator with `LIKE` operat"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"or with index:"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+msgstr "元の`LIKE`演算子とインデックスを使った`LIKE`演算子で同じ結果が返ります。"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+msgid ""</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"```sql\n"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"SET enable_seqscan = off;\n"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"SET enable_indexscan = on;\n"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"SET enable_bitmapscan = on;\n"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"SELECT * FROM memos WHERE content LIKE '%groonga%';\n"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"-- id | content \n"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"-- ----+-----------------------------\n"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"-- 4 | groongaコマンドがあります。\n"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"-- (1 行)\n"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"```"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+msgstr ""</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+msgid ""</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"Normally, the default configuration returns better result for full text search"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+" rather than the original `LIKE` operator. Think about which result is better "</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"for users before you change the default configuration."</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+msgstr ""</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"通常、デフォルトの設定は元の`LIKE`演算子よりも適切な全文検索結果を返す設定です。もし、デフォルトの設定をするときは、変更する前にユーザーにとてどのよう"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"な結果が適切かを考えてください。"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+msgid ""</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"See [Customization in `CREATE INDEX USING pgroonga`](../create-index-using-pgr"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"oonga.html#customization) for tokenizer and normalizer."</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+msgstr ""</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"トークナイザーとノーマライザーをカスタマイズする方法については[`CREATE INDEX USING pgroonga`のカスタマイズ](../creat"</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+"e-index-using-pgroonga.html#customization)を参照してください。"</span>
</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"><span class="diff-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre"> Added: ja/reference/operators/like.md (+74 -0) 100644</span>
<span class="diff-header-mark" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">===================================================================</span>
</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"><span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3">...</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
</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"><span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3">...</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R1">1</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R2">2</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R3">3</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R4">4</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R5">5</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R6">6</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R7">7</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R8">8</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R9">9</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R10">10</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R11">11</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R12">12</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R13">13</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R14">14</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R15">15</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R16">16</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R17">17</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R18">18</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R19">19</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R20">20</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R21">21</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R22">22</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R23">23</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R24">24</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R25">25</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R26">26</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R27">27</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R28">28</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R29">29</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R30">30</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R31">31</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R32">32</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R33">33</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R34">34</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R35">35</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R36">36</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R37">37</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R38">38</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R39">39</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R40">40</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R41">41</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R42">42</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R43">43</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R44">44</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R45">45</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R46">46</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R47">47</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R48">48</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R49">49</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R50">50</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R51">51</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R52">52</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R53">53</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R54">54</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R55">55</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R56">56</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R57">57</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R58">58</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R59">59</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R60">60</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R61">61</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R62">62</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R63">63</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R64">64</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R65">65</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R66">66</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R67">67</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R68">68</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R69">69</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R70">70</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R71">71</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R72">72</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R73">73</a></span>
<span class="diff-line-number-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/a3048b049d6e8d97a664e39701d6f8f55f427c4b#diff-e996d83cfb861feceb0be74b8a646fd3R74">74</a></span>
</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"><span class="diff-hunk-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">@@ -0,0 +1,74 @@</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+---</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+title: LIKE演算子</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+layout: ja</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+---</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+# `LIKE`演算子</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+PGroongaは内部的に`column LIKE '%キーワード%'`条件を`column %% 'キーワード'`条件に変換します。[`%%`演算子](match.html)はインデックスを使って全文検索をします。これはインデックスを使わない`LIKE`演算子より速いです。</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+最初の`%`と最後の`%`はどちらも重要です。`'キーワード%'`、`'%キーワード'`などは`column %% 'キーワード'`に変換されます。このようなパターンを指定するとPGroongaは1件もレコードを返しません。なぜならPGroongaはインデックスなしではこれらのパターンを検索できないからです。</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+元の`LIKE`演算子は対象テキストに対して検索します。しかし、`%%`演算子は正規化したテキストに対して検索します。これは、インデックスを使った`LIKE`演算子の検索結果と、元の`LIKE`演算子の検索結果は異なるということです。</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+たとえば、元の`LIKE`演算子は大文字小文字を区別して検索します。しかし、インデックスを使った`LIKE`演算子は大文字小文字を区別しません。</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+元の`LIKE`演算子の結果です。</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+```sql</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+SET enable_seqscan = on;</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+SET enable_indexscan = off;</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+SET enable_bitmapscan = off;</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+SELECT * FROM memos WHERE content LIKE '%groonga%';</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+-- id | content </span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+-- ----+-----------------------------</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+-- 4 | groongaコマンドがあります。</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+-- (1 行)</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+```</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+インデックスを使った`LIKE`演算子の結果です。</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+```sql</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+SET enable_seqscan = off;</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+SET enable_indexscan = on;</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+SET enable_bitmapscan = on;</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+SELECT * FROM memos WHERE content LIKE '%groonga%';</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+-- id | content </span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+-- ----+---------------------------------------------------------------------------</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+-- 2 | Groongaは日本語対応の高速な全文検索エンジンです。</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+-- 3 | PGroongaはインデックスとしてGroongaを使うためのPostgreSQLの拡張機能です。</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+-- 4 | groongaコマンドがあります。</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+-- (3 行)</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+```</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+インデックスを使った`LIKE`演算子の結果と元の`LIKE`演算子の結果を同じにしたい場合は次のトークナイザーとノーマライザーを使います。</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+ * トークナイザー: `TokenBigramSplitSymbolAlphaDigit`</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+ * ノーマライザー: なし</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+具体例は次の通りです。</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+```sql</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+CREATE INDEX pgroonga_content_index</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+ ON memos</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+ USING pgroonga (content)</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+ WITH (tokenizer='TokenBigramSplitSymbolAlphaDigit',</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+ normalizer='');</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+```</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+元の`LIKE`演算子とインデックスを使った`LIKE`演算子で同じ結果が返ります。</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+```sql</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+SET enable_seqscan = off;</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+SET enable_indexscan = on;</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+SET enable_bitmapscan = on;</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+SELECT * FROM memos WHERE content LIKE '%groonga%';</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+-- id | content </span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+-- ----+-----------------------------</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+-- 4 | groongaコマンドがあります。</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+-- (1 行)</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+```</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+通常、デフォルトの設定は元の`LIKE`演算子よりも適切な全文検索結果を返す設定です。もし、デフォルトの設定をするときは、変更する前にユーザーにとてどのような結果が適切かを考えてください。</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+トークナイザーとノーマライザーをカスタマイズする方法については[`CREATE INDEX USING pgroonga`のカスタマイズ](../create-index-using-pgroonga.html#customization)を参照してください。</span>
</pre>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>