<!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 &lt;kou****@clear*****&gt;</dd>
      <dt style="clear: both; float: left; font-weight: bold; width: 8em">Date</dt>
      <dd style="margin-left: 8.5em">2015-10-25 22:09:56 +0900 (Sun, 25 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/cf1fec5fbf94bc95859bc8816540705b0f81777b">cf1fec5fbf94bc95859bc8816540705b0f81777b</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, &quot;Liberation Mono&quot;, Courier, monospace; line-height: 1.2; padding: 0.5em; width: auto">Use common format</pre></dd>
      <dt style="clear: both; float: left; font-weight: bold; width: 8em">Modified files</dt>
      <dd style="margin-left: 8.5em">
        <ul>
          <li><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4b">_po/ja/reference/operators/like.po</a></li>
          <li><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-e996d83cfb861feceb0be74b8a646fd3">ja/reference/operators/like.md</a></li>
          <li><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53">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, &quot;Liberation Mono&quot;, 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">  Modified: _po/ja/reference/operators/like.po (+42 -16)</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, &quot;Liberation Mono&quot;, 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/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4b">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL1">1</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL2">2</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL3">3</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL4">4</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL5">5</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL6">6</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL7">7</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL21">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL22">22</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL23">23</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL24">24</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL25">25</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL26">26</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL27">27</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL29">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL30">30</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL31">31</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL32">32</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL33">33</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL34">34</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL35">35</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL37">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL38">38</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL39">39</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL40">40</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL41">41</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL42">42</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL43">43</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL44">44</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL45">45</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL46">46</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL47">47</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL48">48</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL49">49</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL50">50</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL51">51</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL52">52</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL53">53</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL54">54</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL55">55</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL56">56</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL57">57</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL58">58</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL59">59</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL86">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL87">87</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL88">88</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL89">89</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL90">90</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL91">91</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL92">92</a></span>
</pre>
            </th>
            <th class="diff-line-number" style="border: 1px solid #aaa">
<pre style="border: 0; font-family: Consolas, Menlo, &quot;Liberation Mono&quot;, 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/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4b">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR1">1</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR2">2</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR3">3</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</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/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR4">4</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR5">5</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR6">6</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR7">7</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR21">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR22">22</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR23">23</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#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/cf1fec5fbf94bc95859bc8816540705b0f81777b#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/cf1fec5fbf94bc95859bc8816540705b0f81777b#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/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR27">27</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR28">28</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR29">29</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR30">30</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR32">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR33">33</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR34">34</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#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/cf1fec5fbf94bc95859bc8816540705b0f81777b#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/cf1fec5fbf94bc95859bc8816540705b0f81777b#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/cf1fec5fbf94bc95859bc8816540705b0f81777b#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/cf1fec5fbf94bc95859bc8816540705b0f81777b#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/cf1fec5fbf94bc95859bc8816540705b0f81777b#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/cf1fec5fbf94bc95859bc8816540705b0f81777b#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/cf1fec5fbf94bc95859bc8816540705b0f81777b#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/cf1fec5fbf94bc95859bc8816540705b0f81777b#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/cf1fec5fbf94bc95859bc8816540705b0f81777b#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/cf1fec5fbf94bc95859bc8816540705b0f81777b#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/cf1fec5fbf94bc95859bc8816540705b0f81777b#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/cf1fec5fbf94bc95859bc8816540705b0f81777b#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/cf1fec5fbf94bc95859bc8816540705b0f81777b#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/cf1fec5fbf94bc95859bc8816540705b0f81777b#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/cf1fec5fbf94bc95859bc8816540705b0f81777b#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/cf1fec5fbf94bc95859bc8816540705b0f81777b#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/cf1fec5fbf94bc95859bc8816540705b0f81777b#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/cf1fec5fbf94bc95859bc8816540705b0f81777b#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/cf1fec5fbf94bc95859bc8816540705b0f81777b#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/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR55">55</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR56">56</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR57">57</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR58">58</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR60">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR61">61</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR62">62</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR63">63</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</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/cf1fec5fbf94bc95859bc8816540705b0f81777b#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/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR65">65</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR66">66</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</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/cf1fec5fbf94bc95859bc8816540705b0f81777b#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/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR68">68</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR69">69</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR70">70</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR71">71</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR98">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR99">99</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR100">100</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#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/cf1fec5fbf94bc95859bc8816540705b0f81777b#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/cf1fec5fbf94bc95859bc8816540705b0f81777b#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/cf1fec5fbf94bc95859bc8816540705b0f81777b#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/cf1fec5fbf94bc95859bc8816540705b0f81777b#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/cf1fec5fbf94bc95859bc8816540705b0f81777b#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/cf1fec5fbf94bc95859bc8816540705b0f81777b#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/cf1fec5fbf94bc95859bc8816540705b0f81777b#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/cf1fec5fbf94bc95859bc8816540705b0f81777b#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/cf1fec5fbf94bc95859bc8816540705b0f81777b#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/cf1fec5fbf94bc95859bc8816540705b0f81777b#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/cf1fec5fbf94bc95859bc8816540705b0f81777b#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/cf1fec5fbf94bc95859bc8816540705b0f81777b#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/cf1fec5fbf94bc95859bc8816540705b0f81777b#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/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR115">115</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR116">116</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR117">117</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR118">118</a></span>
</pre>
            </th>
            <td class="diff-content" style="border: 1px solid #aaa">
<pre style="border: 0; font-family: Consolas, Menlo, &quot;Liberation Mono&quot;, 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">@@ -1,7 +1,7 @@</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> msgid &quot;&quot;</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> msgstr &quot;&quot;</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> &quot;Project-Id-Version: PACKAGE VERSION\n&quot;</span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">-&quot;PO-Revision-Date: 2015-10-25 22:0<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">0</span>+0900\n&quot;</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+&quot;PO-Revision-Date: 2015-10-25 22:0<span class="diff-added-word" style="background-color: #a6f3a6; color: #000000">8</span>+0900\n&quot;</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> &quot;Language: ja\n&quot;</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> &quot;MIME-Version: 1.0\n&quot;</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> &quot;Content-Type: text/plain; charset=UTF-8\n&quot;</span>
<span class="diff-hunk-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">@@ -22,6 +22,9 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">msgstr &quot;&quot;</span></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> msgid &quot;# `LIKE` operator&quot;</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> msgstr &quot;# `LIKE`演算子&quot;</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+msgid &quot;## Summary&quot;</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+msgstr &quot;## 概要&quot;</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> msgid &quot;&quot;</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> &quot;PGroonga converts `column LIKE &#39;%KEYWORD%&#39;` condition to `column %% &#39;KEYWORD&#39;`&quot;</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> &quot; internally. [`%%` operator](match.html) does full text search with index. It&#39;&quot;</span>
<span class="diff-hunk-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">@@ -30,6 +33,26 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">msgstr &quot;&quot;</span></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> &quot;PGroongaは内部的に`column LIKE &#39;%キーワード%&#39;`条件を`column %% &#39;キーワード&#39;`条件に変換します。[`%%`演算子](m&quot;</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> &quot;atch.html)はインデックスを使って全文検索をします。これはインデックスを使わない`LIKE`演算子より速いです。&quot;</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+msgid &quot;## Syntax&quot;</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+msgstr &quot;## 構文&quot;</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 &quot;Here is the syntax of this operator:&quot;</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+msgstr &quot;この演算子の構文は次の通りです。&quot;</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 &quot;&quot;</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+&quot;```sql\n&quot;</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+&quot;column LIKE pattern\n&quot;</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+&quot;```&quot;</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+msgstr &quot;&quot;</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 &quot;`column` is a column to be searched.&quot;</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+msgstr &quot;`column`は検索対象のカラムです。&quot;</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 &quot;&quot;</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+&quot;`pattern` is a search pattern. It&#39;s `text` type. It must be `&#39;%KEYWORD%&#39;` form&quot;</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+&quot;at.&quot;</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+msgstr &quot;`pattern`は検索パターンです。`text`型です。`&#39;%キーワード%&#39;`というフォーマットではなければいけません。&quot;</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> msgid &quot;&quot;</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> &quot;Both beginning `%` and ending `%` are important. `&#39;KEYWORD%&#39;`, `&#39;%KEYWORD&#39;` an&quot;</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> &quot;d so on aren&#39;t converted to `column %% &#39;KEYWORD&#39;`. PGroonga returns no records&quot;</span>
<span class="diff-hunk-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">@@ -38,22 +61,11 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">msgstr &quot;&quot;</span></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> &quot;最初の`%`と最後の`%`はどちらも重要です。`&#39;キーワード%&#39;`、`&#39;%キーワード&#39;`などは`column %% &#39;キーワード&#39;`に変換されます。このよう&quot;</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> &quot;なパターンを指定するとPGroongaは1件もレコードを返しません。なぜならPGroongaはインデックスなしではこれらのパターンを検索できないからです。&quot;</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">-msgid &quot;&quot;</span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">-&quot;The original `LIKE` operator searches against text as is. But `%%` operator do&quot;</span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">-&quot;es full text search against normalized text. It means that search result of `L&quot;</span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">-&quot;IKE` operator with index and search result of the original `LIKE` operator may&quot;</span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">-&quot; be different.&quot;</span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">-msgstr &quot;&quot;</span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">-&quot;元の`LIKE`演算子は対象テキストに対して検索します。しかし、`%%`演算子は正規化したテキストに対して検索します。これは、インデックスを使った`LIKE&quot;</span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">-&quot;`演算子の検索結果と、元の`LIKE`演算子の検索結果は異なるということです。&quot;</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+msgid &quot;## Usage&quot;</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+msgstr &quot;## 使い方&quot;</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">-msgid &quot;&quot;</span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">-&quot;For example, the original `LIKE` operator searches with case sensitive. But `L&quot;</span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">-&quot;IKE` operator with index searches with case insensitive.&quot;</span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">-msgstr &quot;たとえば、元の`LIKE`演算子は大文字小文字を区別して検索します。しかし、インデックスを使った`LIKE`演算子は大文字小文字を区別しません。&quot;</span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">-</span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">-msgid &quot;Here are sample schema and data:&quot;</span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">-msgstr &quot;&quot;</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+msgid &quot;Here are sample schema and data for examples:&quot;</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+msgstr &quot;例に使うサンプルスキーマとデータは次の通りです。&quot;</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-not-changed" style="display: block; white-space: pre"> msgid &quot;&quot;</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> &quot;```sql\n&quot;</span>
<span class="diff-hunk-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">@@ -87,6 +99,20 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">msgstr &quot;&quot;</span></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> &quot;INSERT INTO memos VALUES (4, &#39;groongaコマンドがあります。&#39;);\n&quot;</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> &quot;```&quot;</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+msgid &quot;&quot;</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+&quot;The original `LIKE` operator searches against text as is. But `%%` operator do&quot;</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+&quot;es full text search against normalized text. It means that search result of `L&quot;</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+&quot;IKE` operator with index and search result of the original `LIKE` operator may&quot;</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+&quot; be different.&quot;</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+msgstr &quot;&quot;</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+&quot;元の`LIKE`演算子は対象テキストに対して検索します。しかし、`%%`演算子は正規化したテキストに対して検索します。これは、インデックスを使った`LIKE&quot;</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+&quot;`演算子の検索結果と、元の`LIKE`演算子の検索結果は異なるということです。&quot;</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 &quot;&quot;</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+&quot;For example, the original `LIKE` operator searches with case sensitive. But `L&quot;</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+&quot;IKE` operator with index searches with case insensitive.&quot;</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+msgstr &quot;たとえば、元の`LIKE`演算子は大文字小文字を区別して検索します。しかし、インデックスを使った`LIKE`演算子は大文字小文字を区別しません。&quot;</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> msgid &quot;A search result of the original `LIKE` operator:&quot;</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> msgstr &quot;元の`LIKE`演算子の結果です。&quot;</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </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, &quot;Liberation Mono&quot;, 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">  Modified: ja/reference/operators/like.md (+20 -4)</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, &quot;Liberation Mono&quot;, 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/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-e996d83cfb861feceb0be74b8a646fd3L4">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-e996d83cfb861feceb0be74b8a646fd3L5">5</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-e996d83cfb861feceb0be74b8a646fd3L6">6</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-e996d83cfb861feceb0be74b8a646fd3L7">7</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-e996d83cfb861feceb0be74b8a646fd3L8">8</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-e996d83cfb861feceb0be74b8a646fd3L9">9</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-e996d83cfb861feceb0be74b8a646fd3L10">10</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-e996d83cfb861feceb0be74b8a646fd3L11">11</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-e996d83cfb861feceb0be74b8a646fd3L12">12</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-e996d83cfb861feceb0be74b8a646fd3L13">13</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-e996d83cfb861feceb0be74b8a646fd3L14">14</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-e996d83cfb861feceb0be74b8a646fd3L15">15</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-e996d83cfb861feceb0be74b8a646fd3L16">16</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-e996d83cfb861feceb0be74b8a646fd3L17">17</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-e996d83cfb861feceb0be74b8a646fd3L18">18</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-e996d83cfb861feceb0be74b8a646fd3L19">19</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-e996d83cfb861feceb0be74b8a646fd3L30">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-e996d83cfb861feceb0be74b8a646fd3L31">31</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-e996d83cfb861feceb0be74b8a646fd3L32">32</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-e996d83cfb861feceb0be74b8a646fd3L33">33</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-e996d83cfb861feceb0be74b8a646fd3L34">34</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-e996d83cfb861feceb0be74b8a646fd3L35">35</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-e996d83cfb861feceb0be74b8a646fd3L36">36</a></span>
</pre>
            </th>
            <th class="diff-line-number" style="border: 1px solid #aaa">
<pre style="border: 0; font-family: Consolas, Menlo, &quot;Liberation Mono&quot;, 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/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-e996d83cfb861feceb0be74b8a646fd3R4">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-e996d83cfb861feceb0be74b8a646fd3R5">5</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-e996d83cfb861feceb0be74b8a646fd3R6">6</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#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/cf1fec5fbf94bc95859bc8816540705b0f81777b#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/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-e996d83cfb861feceb0be74b8a646fd3R9">9</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-e996d83cfb861feceb0be74b8a646fd3R10">10</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-e996d83cfb861feceb0be74b8a646fd3R11">11</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</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/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-e996d83cfb861feceb0be74b8a646fd3R12">12</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-e996d83cfb861feceb0be74b8a646fd3R13">13</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</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/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-e996d83cfb861feceb0be74b8a646fd3R14">14</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-e996d83cfb861feceb0be74b8a646fd3R15">15</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</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/cf1fec5fbf94bc95859bc8816540705b0f81777b#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/cf1fec5fbf94bc95859bc8816540705b0f81777b#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/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-e996d83cfb861feceb0be74b8a646fd3R18">18</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-e996d83cfb861feceb0be74b8a646fd3R19">19</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</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/cf1fec5fbf94bc95859bc8816540705b0f81777b#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/cf1fec5fbf94bc95859bc8816540705b0f81777b#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/cf1fec5fbf94bc95859bc8816540705b0f81777b#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/cf1fec5fbf94bc95859bc8816540705b0f81777b#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/cf1fec5fbf94bc95859bc8816540705b0f81777b#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/cf1fec5fbf94bc95859bc8816540705b0f81777b#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/cf1fec5fbf94bc95859bc8816540705b0f81777b#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/cf1fec5fbf94bc95859bc8816540705b0f81777b#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/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-e996d83cfb861feceb0be74b8a646fd3R28">28</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-e996d83cfb861feceb0be74b8a646fd3R29">29</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-e996d83cfb861feceb0be74b8a646fd3R30">30</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-e996d83cfb861feceb0be74b8a646fd3R31">31</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-e996d83cfb861feceb0be74b8a646fd3R42">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-e996d83cfb861feceb0be74b8a646fd3R43">43</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-e996d83cfb861feceb0be74b8a646fd3R44">44</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#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/cf1fec5fbf94bc95859bc8816540705b0f81777b#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/cf1fec5fbf94bc95859bc8816540705b0f81777b#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/cf1fec5fbf94bc95859bc8816540705b0f81777b#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/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-e996d83cfb861feceb0be74b8a646fd3R49">49</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-e996d83cfb861feceb0be74b8a646fd3R50">50</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-e996d83cfb861feceb0be74b8a646fd3R51">51</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-e996d83cfb861feceb0be74b8a646fd3R52">52</a></span>
</pre>
            </th>
            <td class="diff-content" style="border: 1px solid #aaa">
<pre style="border: 0; font-family: Consolas, Menlo, &quot;Liberation Mono&quot;, 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">@@ -5,15 +5,27 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">layout: ja</span></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-not-changed" style="display: block; white-space: pre"> # `LIKE`演算子</span>
<span class="diff-not-changed" style="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-not-changed" style="display: block; white-space: pre"> PGroongaは内部的に`column LIKE &#39;%キーワード%&#39;`条件を`column %% &#39;キーワード&#39;`条件に変換します。[`%%`演算子](match.html)はインデックスを使って全文検索をします。これはインデックスを使わない`LIKE`演算子より速いです。</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">-<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">最初の`%`と最後の`%`はどちらも重要です。`&#39;キーワード%&#39;`、`&#39;%キーワード&#39;`などは`column</span> <span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">%% &#39;キーワード&#39;`に変換されます。このようなパターンを指定するとPGroongaは1件もレコードを返しません。なぜならPGroongaはインデックスなしではこれらのパターンを検索できないからです。</span></span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+<span class="diff-added-word" style="background-color: #a6f3a6; color: #000000">##</span> <span class="diff-added-word" style="background-color: #a6f3a6; color: #000000">構文</span></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">-<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">元の`LIKE`演算子は対象テキストに対して検索します。しかし、`%%`演算子は正規化したテキストに対して検索します。</span>こ<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">れは、インデックスを使った`LIKE`演算子</span>の<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">検索結果と、元の`LIKE`</span>演算子の<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">検索結果</span>は<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">異なるということ</span>です。</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+この演算子の<span class="diff-added-word" style="background-color: #a6f3a6; color: #000000">構文</span>は<span class="diff-added-word" style="background-color: #a6f3a6; color: #000000">次の通り</span>です。</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-deleted" style="background-color: #ffdddd; 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">+```sql</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+column LIKE pattern</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+```</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">-Here are sample schema and data:</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">+</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+`pattern`は検索パターンです。`text`型です。`&#39;%キーワード%&#39;`というフォーマットではなければいけません。</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">+最初の`%`と最後の`%`はどちらも重要です。`&#39;キーワード%&#39;`、`&#39;%キーワード&#39;`などは`column %% &#39;キーワード&#39;`に変換されます。このようなパターンを指定すると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">+## 使い方</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-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-not-changed" style="display: block; white-space: pre"> ```sql</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> CREATE TABLE memos (</span>
<span class="diff-hunk-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">@@ -31,6 +43,10 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">INSERT INTO memos VALUES (3, &#39;PGroongaはインデックスとしてGroongaを</span></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> INSERT INTO memos VALUES (4, &#39;groongaコマンドがあります。&#39;);</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> ```</span>
<span class="diff-not-changed" style="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-not-changed" style="display: block; white-space: pre"> 元の`LIKE`演算子の結果です。</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-not-changed" style="display: block; white-space: pre"> ```sql</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, &quot;Liberation Mono&quot;, 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">  Modified: reference/operators/like.md (+20 -4)</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, &quot;Liberation Mono&quot;, 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/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53L4">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53L5">5</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53L6">6</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53L7">7</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53L8">8</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53L9">9</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53L10">10</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53L11">11</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53L12">12</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53L13">13</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53L14">14</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53L15">15</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53L16">16</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53L17">17</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53L18">18</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53L19">19</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53L30">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53L31">31</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53L32">32</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53L33">33</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53L34">34</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53L35">35</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53L36">36</a></span>
</pre>
            </th>
            <th class="diff-line-number" style="border: 1px solid #aaa">
<pre style="border: 0; font-family: Consolas, Menlo, &quot;Liberation Mono&quot;, 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/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53R4">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53R5">5</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53R6">6</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53R7">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/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53R8">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/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53R9">9</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53R10">10</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53R11">11</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</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/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53R12">12</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53R13">13</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</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/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53R14">14</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53R15">15</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</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/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53R16">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/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53R17">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/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53R18">18</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53R19">19</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</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/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53R20">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/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53R21">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/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53R22">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/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53R23">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/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53R24">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/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53R25">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/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53R26">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/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53R27">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/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53R28">28</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53R29">29</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53R30">30</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53R31">31</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53R42">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53R43">43</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53R44">44</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53R45">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/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53R46">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/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53R47">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/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53R48">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/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53R49">49</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53R50">50</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53R51">51</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/cf1fec5fbf94bc95859bc8816540705b0f81777b#diff-274aa778ac04b071db2006aec4aa3f53R52">52</a></span>
</pre>
            </th>
            <td class="diff-content" style="border: 1px solid #aaa">
<pre style="border: 0; font-family: Consolas, Menlo, &quot;Liberation Mono&quot;, 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">@@ -5,15 +5,27 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">layout: en</span></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-not-changed" style="display: block; white-space: pre"> # `LIKE` operator</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+## Summary</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> PGroonga converts `column LIKE &#39;%KEYWORD%&#39;` condition to `column %% &#39;KEYWORD&#39;` internally. [`%%` operator](match.html) does full text search with index. It&#39;s fast rather than `LIKE` operator without index.</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">-<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">Both</span> <span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">begi</span>n<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">ning `%` and ending `%` are impor</span>ta<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">nt. `&#39;KEYWORD%&#39;`, `&#39;%KEYWORD&#39;` and so on aren&#39;t converted to `column %% &#39;KEYWORD&#39;`. PGroonga returns no records for these patterns. Because PGroonga can&#39;t search these patterns with inde</span>x<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">.</span></span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+<span class="diff-added-word" style="background-color: #a6f3a6; color: #000000">##</span> <span class="diff-added-word" style="background-color: #a6f3a6; color: #000000">Sy</span>ntax</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">-<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">Th</span>e<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000"> o</span>r<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">iginal `LIKE` op</span>e<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">rator</span> <span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">searches aga</span>i<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">n</span>s<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">t</span> te<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">xt</span> <span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">a</span>s<span class="diff-delete
 d-word" 
 style="background-color: #f8cbcb; color: #000000"> is. But `%%` operator does full text search agai</span>n<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">s</span>t<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000"> norm</span>a<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">lized te</span>x<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">t.</span> <span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">It means that search result </span>of <span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">`LIKE` opera</span>t<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">or wit</span>h<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000"> </span>i<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">ndex and </span
 >s<span 
 class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">earch</span> <span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">result </span>o<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000">f the original `LIKE` o</span>perator<span class="diff-deleted-word" style="background-color: #f8cbcb; color: #000000"> may be different.</span></span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+<span class="diff-added-word" style="background-color: #a6f3a6; color: #000000">H</span>ere is t<span class="diff-added-word" style="background-color: #a6f3a6; color: #000000">h</span>e s<span class="diff-added-word" style="background-color: #a6f3a6; color: #000000">y</span>ntax of this operator<span class="diff-added-word" style="background-color: #a6f3a6; color: #000000">:</span></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">-For example, the original `LIKE` operator searches with case sensitive. But `LIKE` operator with index searches with case insensitive.</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">+column LIKE pattern</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+```</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-deleted" style="background-color: #ffdddd; color: #000000; display: block; white-space: pre">-Here are sample schema and data:</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+`column` is a column to be searched.</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">+`pattern` is a search pattern. It&#39;s `text` type. It must be `&#39;%KEYWORD%&#39;` format.</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">+Both beginning `%` and ending `%` are important. `&#39;KEYWORD%&#39;`, `&#39;%KEYWORD&#39;` and so on aren&#39;t converted to `column %% &#39;KEYWORD&#39;`. PGroonga returns no records for these patterns. Because PGroonga can&#39;t search these patterns with index.</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">+## Usage</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">+Here are sample schema and data for examples:</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-not-changed" style="display: block; white-space: pre"> ```sql</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> CREATE TABLE memos (</span>
<span class="diff-hunk-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">@@ -31,6 +43,10 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">INSERT INTO memos VALUES (3, &#39;PGroonga is a PostgreSQL extension that uses Groon</span></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> INSERT INTO memos VALUES (4, &#39;There is groonga command.&#39;);</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> ```</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </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 does full text search against normalized text. It means that search result of `LIKE` operator with index and search result of the original `LIKE` operator may be different.</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">+For example, the original `LIKE` operator searches with case sensitive. But `LIKE` operator with index searches with case insensitive.</span>
<span class="diff-added" style="background-color: #dbffdb; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> A search result of the original `LIKE` operator:</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-not-changed" style="display: block; white-space: pre"> ```sql</span>
</pre>
            </td>
          </tr>
        </tbody>
      </table>
    </div>
  </body>
</html>