<!DOCTYPE html> <html> <head> </head> <body> <dl style="line-height: 1.5; margin-left: 2em"> <dt style="clear: both; float: left; font-weight: bold; width: 8em">Author</dt> <dd style="margin-left: 8.5em">Kouhei Sutou <kou****@clear*****></dd> <dt style="clear: both; float: left; font-weight: bold; width: 8em">Date</dt> <dd style="margin-left: 8.5em">2015-10-24 09:39:18 +0900 (Sat, 24 Oct 2015)</dd> <dt style="clear: both; float: left; font-weight: bold; width: 8em">New Revision</dt> <dd style="margin-left: 8.5em"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1">2614504073a1fffca3c860ee04e00b4f4caa19d1</a></dd> <dt style="clear: both; float: left; font-weight: bold; width: 8em">Message</dt> <dd style="margin-left: 8.5em"><pre style="border: 1px solid #aaa; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; padding: 0.5em; width: auto">Translate CREATE INDEX</pre></dd> <dt style="clear: both; float: left; font-weight: bold; width: 8em">Added files</dt> <dd style="margin-left: 8.5em"> <ul> <li><a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaef">_po/ja/reference/create-index-using-pgroonga.po</a></li> <li><a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ce">ja/reference/create-index-using-pgroonga.md</a></li> </ul> </dd> <dt style="clear: both; float: left; font-weight: bold; width: 8em">Modified files</dt> <dd style="margin-left: 8.5em"> <ul> <li><a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2348298c2ffbf92ae17422df9186a527">reference/create-index-using-pgroonga.md</a></li> </ul> </dd> </dl> <div class="diff-section" style="clear: both"> <table style="border-collapse: collapse; border: 1px solid #aaa"> <thead> <tr class="diff-header" style="border: 1px solid #aaa"> <td colspan="3"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"> Added: _po/ja/reference/create-index-using-pgroonga.po (+248 -0) 100644 =================================================================== </pre> </td> </tr> </thead> <tbody> <tr> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaef">...</a>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 </pre> </th> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaef">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR1">1</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR2">2</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR3">3</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR4">4</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR5">5</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR6">6</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR7">7</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR8">8</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR9">9</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR10">10</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR11">11</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR12">12</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR13">13</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR14">14</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR15">15</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR16">16</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR17">17</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR18">18</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR19">19</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR20">20</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR21">21</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR22">22</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR23">23</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR24">24</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR25">25</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR26">26</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR27">27</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR28">28</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR29">29</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR30">30</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR31">31</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR32">32</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR33">33</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR34">34</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR35">35</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR36">36</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR37">37</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR38">38</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR39">39</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR40">40</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR41">41</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR42">42</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR43">43</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR44">44</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR45">45</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR46">46</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR47">47</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR48">48</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR49">49</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR50">50</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR51">51</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR52">52</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR53">53</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR54">54</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR55">55</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR56">56</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR57">57</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR58">58</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR59">59</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR60">60</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR61">61</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR62">62</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR63">63</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR64">64</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR65">65</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR66">66</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR67">67</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR68">68</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR69">69</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR70">70</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR71">71</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR72">72</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR73">73</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR74">74</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR75">75</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR76">76</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR77">77</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR78">78</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR79">79</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR80">80</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR81">81</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR82">82</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR83">83</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR84">84</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR85">85</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR86">86</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR87">87</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR88">88</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR89">89</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR90">90</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR91">91</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR92">92</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR93">93</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR94">94</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR95">95</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR96">96</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR97">97</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR98">98</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR99">99</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR100">100</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR101">101</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR102">102</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR103">103</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR104">104</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR105">105</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR106">106</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR107">107</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR108">108</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR109">109</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR110">110</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR111">111</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR112">112</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR113">113</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR114">114</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR115">115</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR116">116</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR117">117</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR118">118</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR119">119</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR120">120</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR121">121</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR122">122</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR123">123</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR124">124</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR125">125</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR126">126</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR127">127</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR128">128</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR129">129</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR130">130</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR131">131</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR132">132</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR133">133</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR134">134</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR135">135</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR136">136</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR137">137</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR138">138</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR139">139</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR140">140</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR141">141</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR142">142</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR143">143</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR144">144</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR145">145</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR146">146</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR147">147</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR148">148</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR149">149</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR150">150</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR151">151</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR152">152</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR153">153</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR154">154</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR155">155</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR156">156</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR157">157</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR158">158</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR159">159</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR160">160</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR161">161</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR162">162</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR163">163</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR164">164</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR165">165</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR166">166</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR167">167</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR168">168</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR169">169</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR170">170</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR171">171</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR172">172</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR173">173</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR174">174</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR175">175</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR176">176</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR177">177</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR178">178</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR179">179</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR180">180</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR181">181</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR182">182</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR183">183</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR184">184</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR185">185</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR186">186</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR187">187</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR188">188</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR189">189</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR190">190</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR191">191</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR192">192</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR193">193</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR194">194</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR195">195</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR196">196</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR197">197</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR198">198</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR199">199</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR200">200</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR201">201</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR202">202</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR203">203</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR204">204</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR205">205</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR206">206</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR207">207</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR208">208</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR209">209</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR210">210</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR211">211</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR212">212</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR213">213</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR214">214</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR215">215</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR216">216</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR217">217</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR218">218</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR219">219</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR220">220</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR221">221</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR222">222</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR223">223</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR224">224</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR225">225</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR226">226</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR227">227</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR228">228</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR229">229</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR230">230</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR231">231</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR232">232</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR233">233</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR234">234</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR235">235</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR236">236</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR237">237</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR238">238</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR239">239</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR240">240</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR241">241</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR242">242</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR243">243</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR244">244</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR245">245</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR246">246</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR247">247</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2dd7fb9df9b69cc2d644b79082cdaaefR248">248</a> </pre> </th> <td class="diff-content" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto">@@ -0,0 +1,248 @@ +msgid "" +msgstr "" +"Project-Id-Version: PACKAGE VERSION\n" +"PO-Revision-Date: 2015-10-24 09:36+0900\n" +"Language: ja\n" +"MIME-Version: 1.0\n" +"Content-Type: text/plain; charset=UTF-8\n" +"Content-Transfer-Encoding: 8bit\n" +"Plural-Forms: nplurals=1; plural=0;\n" + +msgid "" +"---\n" +"title: CREATE INDEX USING pgroonga\n" +"layout: en\n" +"---" +msgstr "" +"---\n" +"title: CREATE INDEX USING pgroonga\n" +"layout: ja\n" +"---" + +msgid "# `CREATE INDEX USING pgroonga`" +msgstr "" + +msgid "" +"You need to specify `USING pgroonga` to `CREATE INDEX` to use PGroonga as inde" +"x method. This section describes about `pgroonga` index method." +msgstr "" +"インデックスメソッドとしてPGroongaを使うためには`CREATE INDEX`に`USING pgroonga`を指定します。このセクションでは`pg" +"roonga`インデックスメソッドについて説明します。" + +msgid "## Syntax" +msgstr "## 構文" + +msgid "" +"This section describes only `pgroonga` index method related `CREATE INDEX` syn" +"tax. See [`CREATE INDEX` document by PostgreSQL](http://www.postgresql.org/doc" +"s/{{ site.postgresql_short_version }}/static/sql-createindex.html) for full `C" +"REATE INDEX` syntax." +msgstr "" +"このセクションでは`pgroonga`インデックスメソッド関連の`CREATE INDEX`の構文だけ説明します。完全な`CREATE INDEX`の構文は" +"[PostgreSQLの`CREATE INDEX`のドキュメント](http://www.postgresql.jp/document/{{ site.p" +"ostgresql_short_version }}/html/sql-createindex.html)を参照してください。" + +msgid "Here is a basic syntax for creating a single column index:" +msgstr "シングルカラムインデックスを作成する基本的な構文は次の通りです。" + +msgid "" +"```sql\n" +"CREATE INDEX ${INDEX_NAME}\n" +" ON ${TABLE_NAME}\n" +" USING pgroonga (${COLUMN});\n" +"```" +msgstr "" + +msgid "This syntax can be used for the following cases:" +msgstr "次のケースのときはこの構文を使えます。" + +msgid "" +" * Creating a full text search index for a `text` type column\n" +" * Creating a full text search index for an array of `text` type column\n" +" * Creating a equality condition and comparison conditions search index for a" +" non `text` type columns\n" +" * Creating a equality condition and comparison conditions search index for a" +"n array of non `text` type columns\n" +" * Creating a contain search and complex search index for `jsonb` type column" +msgstr "" +" * `text`型のカラム用の全文検索インデックスを作るとき\n" +" * `text`型の配列のカラム用の全文検索インデックスを作るとき\n" +" * `text`型以外の型のカラム用の等価条件・比較条件検索用インデックスを作るとき\n" +" * `text`型以外の型の配列のカラム用の等価条件・比較条件検索用インデックスを作るとき\n" +" * `jsonb`型のカラム用のサブセット検索・高度な検索用のインデックスを作るとき" + +msgid "" +"Here is a basic syntax for creating a full text search index for a `varchar` t" +"ype column:" +msgstr "`varchar`型のカラム用の全文検索インデックスを作るときの基本的な構文は次の通りです。" + +msgid "" +"```sql\n" +"CREATE INDEX ${INDEX_NAME}\n" +" ON ${TABLE_NAME}\n" +" USING pgroonga (${COLUMN}) pgroonga.varchar_full_text_search_ops;\n" +"```" +msgstr "" + +msgid "" +"You need to specify `pgroonga.varchar_fulltext_search_ops` operator class for " +"the case." +msgstr "この場合は`pgroonga.varchar_fulltext_search_ops`オペレータークラスを指定する必要があります。" + +msgid "{: #customization}" +msgstr "" + +msgid "### Customization" +msgstr "### カスタマイズ" + +msgid "You can custom the followings by `WITH` option of `CREATE INDEX`:" +msgstr "`CREATE INDEX`の`WITH`オプションを使って次の項目をカスタマイズできます。" + +msgid "" +" * Tokenizer: It's a module for customizing how to extract keywords.\n" +" * Normalizer: It's a module for customizing equality of `text` and `varchar`" +" types." +msgstr "" +" * トークナイザー：キーワードの抽出方法をカスタマイズするモジュールです。\n" +" * ノーマライザー：`text`型と`varchar`型の等価性をカスタマイズするモジュールです。" + +msgid "" +"Normally, you don't need to custom them because default values of them are sui" +"table for most cases. Features to custom them are for advanced users." +msgstr "" +"通常、これらをカスタマイズする必要はありません。なぜなら多くの場合で適切なようにデフォルト値が設定されているからです。これらをカスタマイズする機能は高度なユ" +"ーザー向けの機能です。" + +msgid "Here are default tokenizer and normalizer:" +msgstr "デフォルトのトークナイザーとノーマライザーは次の通りです。" + +msgid "" +" * Tokenizer: [`TokenBigram`](http://groonga.org/docs/reference/tokenizers.ht" +"ml#token-bigram): It's a bigram based tokenizer. It combines bigram tokenizati" +"on and white space based tokenization. It uses bigram tokenization for non ASC" +"II characters and white space based tokenization for ASCII characters. It redu" +"ces noise for ASCII characters only query.\n" +" * Normalizer: [`NormalizerAuto`](http://groonga.org/docs/reference/normalize" +"rs.html#normalizer-auto): It chooses suitable normalization based on target en" +"coding. For example, it uses [Unicode NFKC](http://unicode.org/reports/tr15/) " +"based normalization for UTF-8." +msgstr "" +" * トークナイザー：[`TokenBigram`](http://groonga.org/ja/docs/reference/tokenizers.ht" +"ml#token-bigram)：bigramベースのトークナイザーです。このトークナイザーはbigramベースのトークナイズ方法とスペース区切りベースのト" +"ークナイズ方法を組み合わせています。非ASCII文字にはbigramベースのトークナイズ方法を使い、ASCII文字にはスペース区切りベースのトークナイズ方法" +"を使います。これはASCII文字だけのクエリーで検索したときのノイズを減らすためです。\n" +" * ノーマライザー：[`NormalizerAuto`](http://groonga.org/ja/docs/reference/normalizer" +"s.html#normalizer-auto)：対象のエンコーディングに合わせて適切なノーマライズ方法を選びます。たとえば、UTF-8の場合は[Unicod" +"e NFKC](http://unicode.org/reports/tr15/)ベースのノーマライズ方法を使います。" + +msgid "#### How to custom tokenizer" +msgstr "#### トークナイザーのカスタマイズ方法" + +msgid "" +"Specify `tokenizer='${TOKENIZER_NAME}'` for customizing tokenizer. Normally, y" +"ou don't need to custom tokenizer." +msgstr "トークナイザーをカスタマイズするには`tokenizer='${トークナイザー名}'`を指定します。通常、トークナイザーをカスタマイズする必要はありません。" + +msgid "" +"Here is an example to use [MeCab](http://taku910.github.io/mecab/) based token" +"izer. You need to specify `tokenizer='TokenMecab'`. [`TokenMecab`](http://groo" +"nga.org/docs/reference/tokenizers.html#token-mecab) is a name of MeCab based t" +"okenizer." +msgstr "" +"以下は[MeCab](http://taku910.github.io/mecab/)ベースのトークナイザーを使う例です。`tokenizer='Token" +"Mecab'`を指定する必要があります。[`TokenMecab`](http://groonga.org/ja/docs/reference/tokeni" +"zers.html#token-mecab)はMeCabベースのトークナイザーの名前です。" + +msgid "" +"```sql\n" +"CREATE TABLE memos (\n" +" id integer,\n" +" content text\n" +");" +msgstr "" + +msgid "" +"CREATE INDEX pgroonga_content_index\n" +" ON memos\n" +" USING pgroonga (content)\n" +" WITH (tokenizer='TokenMecab');\n" +"```" +msgstr "" + +msgid "" +"You can disable tokenizer by specifying `tokenizer=''`. If you disable tokeniz" +"er, you can search column value only by exact match search and prefix search. " +"It reduces noise for some cases. For example, it's useful for tag search, name" +" search and so on." +msgstr "" +"`tokenizer=''`と指定することでトークナイザーを無効にすることができます。トークナイザーを無効にすると、完全一致検索または前方一致検索のみでカラ" +"ムの値を検索できます。これにより誤ヒットが少なくなるケースがあります。例えば、タグ検索・名前検索などのときは有用です。" + +msgid "Here is an example to disable tokenizer:" +msgstr "以下はトークナイザーを無効にする例です。" + +msgid "" +"```sql\n" +"CREATE TABLE memos (\n" +" id integer,\n" +" tag text\n" +");" +msgstr "" + +msgid "" +"CREATE INDEX pgroonga_tag_index\n" +" ON memos\n" +" USING pgroonga (tag)\n" +" WITH (tokenizer='');\n" +"```" +msgstr "" + +msgid "" +"`tokenizer='TokenDelimit'` will be useful for tag search. See also [`TokenDeli" +"mit`](http://groonga.org/docs/reference/tokenizers.html#token-delimit)." +msgstr "" +"`tokenizer='TokenDelimit'`はタグ検索で便利です。[`TokenDelimit`](http://groonga.org/ja/do" +"cs/reference/tokenizers.html#token-delimit)も参照してください。" + +msgid "" +"See [Tokenizers](http://groonga.org/docs/reference/tokenizers.html) for other " +"tokenizers." +msgstr "" +"他のトークナイザーについては[トークナイザー](http://groonga.org/ja/docs/reference/tokenizers.html)を" +"参照してください。" + +msgid "#### How to custom normalizer" +msgstr "#### ノーマライザーのカスタマイズ方法" + +msgid "" +"Specify `normalizer='${NORMALIZER_NAME}'` for customizing normalizer. Normally" +", you don't need to custom normalizer." +msgstr "" +"ノーマライザーをカスタマイズするには`normalizer='${ノーマライザー名}'`を指定してください。通常はノーマライザーをカスタマイズする必要はあり" +"ません。" + +msgid "" +"You can disable normalizer by specifying `normalizer=''`. If you disable norma" +"lizer, you can search column value only by the original column value. If norma" +"lizer increases noise, it's useful." +msgstr "" +"`normalizer=''`を指定するとノーマライザーを無効にすることができます。ノーマライザーを無効にすると元のカラムの値そのものでだけ検索できます。も" +"し、ノーマライザーを使うことで誤ヒットが増える場合は無効にした方がよいでしょう。" + +msgid "Here is an example to disable normalizer:" +msgstr "ノーマライザーを無効にする方法は次の通りです。" + +msgid "" +"CREATE INDEX pgroonga_tag_index\n" +" ON memos\n" +" USING pgroonga (tag)\n" +" WITH (normalizer='');\n" +"```" +msgstr "" + +msgid "" +"See [Normalizers](http://groonga.org/docs/reference/normalizers.html) for othe" +"r normalizers." +msgstr "" +"他のノーマライザーについては[ノーマライザー](http://groonga.org/ja/docs/reference/normalizers.html)" +"を参照してください。" </pre> </td> </tr> </tbody> </table> <table style="border-collapse: collapse; border: 1px solid #aaa"> <thead> <tr class="diff-header" style="border: 1px solid #aaa"> <td colspan="3"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"> Added: ja/reference/create-index-using-pgroonga.md (+114 -0) 100644 =================================================================== </pre> </td> </tr> </thead> <tbody> <tr> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ce">...</a>                                                                                                                                                                                                                                     </pre> </th> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ce">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR1">1</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR2">2</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR3">3</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR4">4</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR5">5</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR6">6</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR7">7</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR8">8</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR9">9</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR10">10</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR11">11</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR12">12</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR13">13</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR14">14</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR15">15</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR16">16</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR17">17</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR18">18</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR19">19</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR20">20</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR21">21</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR22">22</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR23">23</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR24">24</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR25">25</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR26">26</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR27">27</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR28">28</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR29">29</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR30">30</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR31">31</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR32">32</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR33">33</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR34">34</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR35">35</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR36">36</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR37">37</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR38">38</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR39">39</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR40">40</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR41">41</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR42">42</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR43">43</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR44">44</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR45">45</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR46">46</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR47">47</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR48">48</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR49">49</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR50">50</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR51">51</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR52">52</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR53">53</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR54">54</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR55">55</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR56">56</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR57">57</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR58">58</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR59">59</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR60">60</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR61">61</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR62">62</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR63">63</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR64">64</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR65">65</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR66">66</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR67">67</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR68">68</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR69">69</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR70">70</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR71">71</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR72">72</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR73">73</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR74">74</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR75">75</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR76">76</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR77">77</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR78">78</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR79">79</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR80">80</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR81">81</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR82">82</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR83">83</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR84">84</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR85">85</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR86">86</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR87">87</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR88">88</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR89">89</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR90">90</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR91">91</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR92">92</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR93">93</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR94">94</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR95">95</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR96">96</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR97">97</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR98">98</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR99">99</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR100">100</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR101">101</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR102">102</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR103">103</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR104">104</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR105">105</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR106">106</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR107">107</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR108">108</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR109">109</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR110">110</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR111">111</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR112">112</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR113">113</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-8deb8e3ce78cd261d9b7e652b50153ceR114">114</a> </pre> </th> <td class="diff-content" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto">@@ -0,0 +1,114 @@ +--- +title: CREATE INDEX USING pgroonga +layout: ja +--- + +# `CREATE INDEX USING pgroonga` + +インデックスメソッドとしてPGroongaを使うためには`CREATE INDEX`に`USING pgroonga`を指定します。このセクションでは`pgroonga`インデックスメソッドについて説明します。 + +## 構文 + +このセクションでは`pgroonga`インデックスメソッド関連の`CREATE INDEX`の構文だけ説明します。完全な`CREATE INDEX`の構文は[PostgreSQLの`CREATE INDEX`のドキュメント](http://www.postgresql.jp/document/{{ site.postgresql_short_version }}/html/sql-createindex.html)を参照してください。 + +シングルカラムインデックスを作成する基本的な構文は次の通りです。 + +```sql +CREATE INDEX ${INDEX_NAME} + ON ${TABLE_NAME} + USING pgroonga (${COLUMN}); +``` + +次のケースのときはこの構文を使えます。 + + * `text`型のカラム用の全文検索インデックスを作るとき + * `text`型の配列のカラム用の全文検索インデックスを作るとき + * `text`型以外の型のカラム用の等価条件・比較条件検索用インデックスを作るとき + * `text`型以外の型の配列のカラム用の等価条件・比較条件検索用インデックスを作るとき + * `jsonb`型のカラム用のサブセット検索・高度な検索用のインデックスを作るとき + +`varchar`型のカラム用の全文検索インデックスを作るときの基本的な構文は次の通りです。 + +```sql +CREATE INDEX ${INDEX_NAME} + ON ${TABLE_NAME} + USING pgroonga (${COLUMN}) pgroonga.varchar_full_text_search_ops; +``` + +この場合は`pgroonga.varchar_fulltext_search_ops`オペレータークラスを指定する必要があります。 + +{: #customization} + +### カスタマイズ + +`CREATE INDEX`の`WITH`オプションを使って次の項目をカスタマイズできます。 + + * トークナイザー：キーワードの抽出方法をカスタマイズするモジュールです。 + * ノーマライザー：`text`型と`varchar`型の等価性をカスタマイズするモジュールです。 + +通常、これらをカスタマイズする必要はありません。なぜなら多くの場合で適切なようにデフォルト値が設定されているからです。これらをカスタマイズする機能は高度なユーザー向けの機能です。 + +デフォルトのトークナイザーとノーマライザーは次の通りです。 + + * トークナイザー：[`TokenBigram`](http://groonga.org/ja/docs/reference/tokenizers.html#token-bigram)：bigramベースのトークナイザーです。このトークナイザーはbigramベースのトークナイズ方法とスペース区切りベースのトークナイズ方法を組み合わせています。非ASCII文字にはbigramベースのトークナイズ方法を使い、ASCII文字にはスペース区切りベースのトークナイズ方法を使います。これはASCII文字だけのクエリーで検索したときのノイズを減らすためです。 + * ノーマライザー：[`NormalizerAuto`](http://groonga.org/ja/docs/reference/normalizers.html#normalizer-auto)：対象のエンコーディングに合わせて適切なノーマライズ方法を選びます。たとえば、UTF-8の場合は[Unicode NFKC](http://unicode.org/reports/tr15/)ベースのノーマライズ方法を使います。 + +#### トークナイザーのカスタマイズ方法 + +トークナイザーをカスタマイズするには`tokenizer='${トークナイザー名}'`を指定します。通常、トークナイザーをカスタマイズする必要はありません。 + +以下は[MeCab](http://taku910.github.io/mecab/)ベースのトークナイザーを使う例です。`tokenizer='TokenMecab'`を指定する必要があります。[`TokenMecab`](http://groonga.org/ja/docs/reference/tokenizers.html#token-mecab)はMeCabベースのトークナイザーの名前です。 + +```sql +CREATE TABLE memos ( + id integer, + content text +); + +CREATE INDEX pgroonga_content_index + ON memos + USING pgroonga (content) + WITH (tokenizer='TokenMecab'); +``` + +`tokenizer=''`と指定することでトークナイザーを無効にすることができます。トークナイザーを無効にすると、完全一致検索または前方一致検索のみでカラムの値を検索できます。これにより誤ヒットが少なくなるケースがあります。例えば、タグ検索・名前検索などのときは有用です。 + +以下はトークナイザーを無効にする例です。 + +```sql +CREATE TABLE memos ( + id integer, + tag text +); + +CREATE INDEX pgroonga_tag_index + ON memos + USING pgroonga (tag) + WITH (tokenizer=''); +``` + +`tokenizer='TokenDelimit'`はタグ検索で便利です。[`TokenDelimit`](http://groonga.org/ja/docs/reference/tokenizers.html#token-delimit)も参照してください。 + +他のトークナイザーについては[トークナイザー](http://groonga.org/ja/docs/reference/tokenizers.html)を参照してください。 + +#### ノーマライザーのカスタマイズ方法 + +ノーマライザーをカスタマイズするには`normalizer='${ノーマライザー名}'`を指定してください。通常はノーマライザーをカスタマイズする必要はありません。 + +`normalizer=''`を指定するとノーマライザーを無効にすることができます。ノーマライザーを無効にすると元のカラムの値そのものでだけ検索できます。もし、ノーマライザーを使うことで誤ヒットが増える場合は無効にした方がよいでしょう。 + +ノーマライザーを無効にする方法は次の通りです。 + +```sql +CREATE TABLE memos ( + id integer, + tag text +); + +CREATE INDEX pgroonga_tag_index + ON memos + USING pgroonga (tag) + WITH (normalizer=''); +``` + +他のノーマライザーについては[ノーマライザー](http://groonga.org/ja/docs/reference/normalizers.html)を参照してください。 </pre> </td> </tr> </tbody> </table> <table style="border-collapse: collapse; border: 1px solid #aaa"> <thead> <tr class="diff-header" style="border: 1px solid #aaa"> <td colspan="3"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"> Modified: reference/create-index-using-pgroonga.md (+2 -2) =================================================================== </pre> </td> </tr> </thead> <tbody> <tr> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2348298c2ffbf92ae17422df9186a527L8">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2348298c2ffbf92ae17422df9186a527L9">9</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2348298c2ffbf92ae17422df9186a527L10">10</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2348298c2ffbf92ae17422df9186a527L11">11</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2348298c2ffbf92ae17422df9186a527L12">12</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2348298c2ffbf92ae17422df9186a527L13">13</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2348298c2ffbf92ae17422df9186a527L14">14</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2348298c2ffbf92ae17422df9186a527L15">15</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2348298c2ffbf92ae17422df9186a527L42">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2348298c2ffbf92ae17422df9186a527L43">43</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2348298c2ffbf92ae17422df9186a527L44">44</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2348298c2ffbf92ae17422df9186a527L45">45</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2348298c2ffbf92ae17422df9186a527L46">46</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2348298c2ffbf92ae17422df9186a527L47">47</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2348298c2ffbf92ae17422df9186a527L48">48</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2348298c2ffbf92ae17422df9186a527L49">49</a> </pre> </th> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2348298c2ffbf92ae17422df9186a527R8">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2348298c2ffbf92ae17422df9186a527R9">9</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2348298c2ffbf92ae17422df9186a527R10">10</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2348298c2ffbf92ae17422df9186a527R11">11</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2348298c2ffbf92ae17422df9186a527R12">12</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2348298c2ffbf92ae17422df9186a527R13">13</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2348298c2ffbf92ae17422df9186a527R14">14</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2348298c2ffbf92ae17422df9186a527R15">15</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2348298c2ffbf92ae17422df9186a527R42">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2348298c2ffbf92ae17422df9186a527R43">43</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2348298c2ffbf92ae17422df9186a527R44">44</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2348298c2ffbf92ae17422df9186a527R45">45</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2348298c2ffbf92ae17422df9186a527R46">46</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2348298c2ffbf92ae17422df9186a527R47">47</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2348298c2ffbf92ae17422df9186a527R48">48</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/2614504073a1fffca3c860ee04e00b4f4caa19d1#diff-2348298c2ffbf92ae17422df9186a527R49">49</a> </pre> </th> <td class="diff-content" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto">@@ -9,7 +9,7 @@ You need to specify `USING pgroonga` to `CREATE INDEX` to use PGroonga as index ## Syntax -This section describes only `pgroonga` index method related `CREATE INDEX` syntax. See [CREATE INDEX document by PostgreSQL](http://www.postgresql.org/docs/{{ site.postgresql_short_version }}/static/sql-createindex.html) for full `CREATE INDEX` syntax. +This section describes only `pgroonga` index method related `CREATE INDEX` syntax. See [`CREATE INDEX` document by PostgreSQL](http://www.postgresql.org/docs/{{ site.postgresql_short_version }}/static/sql-createindex.html) for full `CREATE INDEX` syntax. Here is a basic syntax for creating a single column index: @@ -43,7 +43,7 @@ You need to specify `pgroonga.varchar_fulltext_search_ops` operator class for th You can custom the followings by `WITH` option of `CREATE INDEX`: - * Tokenizer: It's a module for full text search. + * Tokenizer: It's a module for customizing how to extract keywords. * Normalizer: It's a module for customizing equality of `text` and `varchar` types. Normally, you don't need to custom them because default values of them are suitable for most cases. Features to custom them are for advanced users. </pre> </td> </tr> </tbody> </table> </div> </body> </html>