<!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-25 22:02:07 +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/b6e5cdfd4e0a81d0e23773215c65b91770da8668">b6e5cdfd4e0a81d0e23773215c65b91770da8668</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">Use English for sample data</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/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4b">_po/ja/reference/operators/like.po</a></li> <li><a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3">ja/reference/operators/like.md</a></li> <li><a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#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, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"> Modified: _po/ja/reference/operators/like.po (+69 -20) =================================================================== </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/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4b">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL1">1</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL2">2</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL3">3</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL4">4</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL5">5</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL6">6</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL7">7</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL51">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL52">52</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL53">53</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL54">54</a>                                                                       <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL55">55</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL56">56</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL57">57</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL58">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL59">59</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL60">60</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL61">61</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL62">62</a>                       <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL63">63</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL64">64</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL65">65</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL66">66</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL67">67</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL68">68</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL69">69</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL70">70</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL71">71</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL72">72</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL74">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL75">75</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL76">76</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL77">77</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL78">78</a>                                 <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL79">79</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL80">80</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL81">81</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL83">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL84">84</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL85">85</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL86">86</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL87">87</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL88">88</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL89">89</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL90">90</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL91">91</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL92">92</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL104">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL105">105</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL106">106</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL107">107</a>         <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL108">108</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL109">109</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL110">110</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL118">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL119">119</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL120">120</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL121">121</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL122">122</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL123">123</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL124">124</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL125">125</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL126">126</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL127">127</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL128">128</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL129">129</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL130">130</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL131">131</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL132">132</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL133">133</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL134">134</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL135">135</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL136">136</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bL137">137</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/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4b">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR1">1</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR2">2</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR3">3</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR4">4</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR5">5</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR6">6</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR7">7</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR51">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR52">52</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR53">53</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR54">54</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR55">55</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR56">56</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR57">57</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR58">58</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR59">59</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR60">60</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR61">61</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR62">62</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR63">63</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR64">64</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR65">65</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR66">66</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR67">67</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR68">68</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR69">69</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR70">70</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR71">71</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR72">72</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR73">73</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR74">74</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR75">75</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR76">76</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR77">77</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR78">78</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR79">79</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR80">80</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR81">81</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR82">82</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR83">83</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR84">84</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR85">85</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR86">86</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR87">87</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR88">88</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR89">89</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR90">90</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR91">91</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR92">92</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR93">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR94">94</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR95">95</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR96">96</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR97">97</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR98">98</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR99">99</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR100">100</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR101">101</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR102">102</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR103">103</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR104">104</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR105">105</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR106">106</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR107">107</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR108">108</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR109">109</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR110">110</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR111">111</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR112">112</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR113">113</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR114">114</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR115">115</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR116">116</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR118">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR119">119</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR120">120</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR121">121</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR122">122</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR123">123</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR124">124</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR125">125</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR126">126</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR127">127</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR128">128</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR129">129</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR130">130</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR131">131</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR132">132</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR133">133</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR134">134</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR135">135</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR136">136</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR137">137</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR138">138</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR139">139</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR140">140</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR142">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR143">143</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR144">144</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR145">145</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR146">146</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR147">147</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR148">148</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR149">149</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR150">150</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR162">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR163">163</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR164">164</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR165">165</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR166">166</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR167">167</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR168">168</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR169">169</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR170">170</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR171">171</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR172">172</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR180">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR181">181</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR182">182</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR183">183</a>                           <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR184">184</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR185">185</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-c8ffa8578fe94bb3ecf76b57252dcc4bR186">186</a> </pre> </th> <td class="diff-content" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto">@@ -1,7 +1,7 @@ msgid "" msgstr "" "Project-Id-Version: PACKAGE VERSION\n" -"PO-Revision-Date: 2015-10-24 17:43+0900\n" +"PO-Revision-Date: 2015-10-25 22:00+0900\n" "Language: ja\n" "MIME-Version: 1.0\n" "Content-Type: text/plain; charset=UTF-8\n" @@ -52,6 +52,41 @@ msgid "" "IKE` operator with index searches with case insensitive." msgstr "たとえば、元の`LIKE`演算子は大文字小文字を区別して検索します。しかし、インデックスを使った`LIKE`演算子は大文字小文字を区別しません。" +msgid "Here are sample schema and data:" +msgstr "" + +msgid "" +"```sql\n" +"CREATE TABLE memos (\n" +" id integer,\n" +" content text\n" +");" +msgstr "" + +msgid "" +"CREATE INDEX pgroonga_content_index ON memos USING pgroonga (content);\n" +"```" +msgstr "" + +msgid "" +"```sql\n" +"INSERT INTO memos VALUES (1, 'PostgreSQL is a relational database management s" +"ystem.');\n" +"INSERT INTO memos VALUES (2, 'Groonga is a fast full text search engine that s" +"upports all languages.');\n" +"INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Gro" +"onga as index.');\n" +"INSERT INTO memos VALUES (4, 'There is groonga command.');\n" +"```" +msgstr "" +"```sql\n" +"INSERT INTO memos VALUES (1, 'PostgreSQLはリレーショナル・データベース管理システムです。');\n" +"INSERT INTO memos VALUES (2, 'Groongaは日本語対応の高速な全文検索エンジンです。');\n" +"INSERT INTO memos VALUES (3, 'PGroongaはインデックスとしてGroongaを使うためのPostgreSQLの拡張機能です" +"。');\n" +"INSERT INTO memos VALUES (4, 'groongaコマンドがあります。');\n" +"```" + msgid "A search result of the original `LIKE` operator:" msgstr "元の`LIKE`演算子の結果です。" @@ -59,14 +94,23 @@ msgid "" "```sql\n" "SET enable_seqscan = on;\n" "SET enable_indexscan = off;\n" -"SET enable_bitmapscan = off;\n" +"SET enable_bitmapscan = off;" +msgstr "" + +msgid "" +"SELECT * FROM memos WHERE content LIKE '%groonga%';\n" +"-- id | content \n" +"-- ----+---------------------------\n" +"-- 4 | There is groonga command.\n" +"-- (1 row)\n" +"```" +msgstr "" "SELECT * FROM memos WHERE content LIKE '%groonga%';\n" "-- id | content \n" "-- ----+-----------------------------\n" "-- 4 | groongaコマンドがあります。\n" -"-- (1 行)\n" +"-- (1 row)\n" "```" -msgstr "" msgid "A search result of `LIKE` operator with index:" msgstr "インデックスを使った`LIKE`演算子の結果です。" @@ -75,7 +119,22 @@ msgid "" "```sql\n" "SET enable_seqscan = off;\n" "SET enable_indexscan = on;\n" -"SET enable_bitmapscan = on;\n" +"SET enable_bitmapscan = on;" +msgstr "" + +msgid "" +"SELECT * FROM memos WHERE content LIKE '%groonga%';\n" +"-- id | content " +" \n" +"-- ----+----------------------------------------------------------------------" +"--\n" +"-- 2 | Groonga is a fast full text search engine that supports all languages" +".\n" +"-- 3 | PGroonga is a PostgreSQL extension that uses Groonga as index.\n" +"-- 4 | There is groonga command.\n" +"-- (3 rows)\n" +"```" +msgstr "" "SELECT * FROM memos WHERE content LIKE '%groonga%';\n" "-- id | content " " \n" @@ -84,9 +143,8 @@ msgid "" "-- 2 | Groongaは日本語対応の高速な全文検索エンジンです。\n" "-- 3 | PGroongaはインデックスとしてGroongaを使うためのPostgreSQLの拡張機能です。\n" "-- 4 | groongaコマンドがあります。\n" -"-- (3 行)\n" +"-- (3 rows)\n" "```" -msgstr "" msgid "" "If you want to get the same result by both `LIKE` operator with index and the " @@ -105,6 +163,10 @@ msgstr "具体例は次の通りです。" msgid "" "```sql\n" +"DROP INDEX IF EXISTS pgroonga_content_index;" +msgstr "" + +msgid "" "CREATE INDEX pgroonga_content_index\n" " ON memos\n" " USING pgroonga (content)\n" @@ -119,19 +181,6 @@ msgid "" msgstr "元の`LIKE`演算子とインデックスを使った`LIKE`演算子で同じ結果が返ります。" msgid "" -"```sql\n" -"SET enable_seqscan = off;\n" -"SET enable_indexscan = on;\n" -"SET enable_bitmapscan = on;\n" -"SELECT * FROM memos WHERE content LIKE '%groonga%';\n" -"-- id | content \n" -"-- ----+-----------------------------\n" -"-- 4 | groongaコマンドがあります。\n" -"-- (1 行)\n" -"```" -msgstr "" - -msgid "" "Normally, the default configuration returns better result for full text search" " rather than the original `LIKE` operator. Think about which result is better " "for users before you change the default configuration." </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: ja/reference/operators/like.md (+26 -3) =================================================================== </pre> </td> </tr> </thead> <tbody> <tr> <th class="diff-line-number" style="border: 1px solid #aaa"> <pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3L12">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3L13">13</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3L14">14</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3L15">15</a>                                     <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3L16">16</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3L17">17</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3L18">18</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3L19">19</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3L20">20</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3L21">21</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3L22">22</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3L23">23</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3L24">24</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3L25">25</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3L26">26</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3L27">27</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3L28">28</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3L29">29</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3L31">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3L32">32</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3L33">33</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3L34">34</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3L35">35</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3L36">36</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3L37">37</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3L38">38</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3L39">39</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3L40">40</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3L41">41</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3L42">42</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3L43">43</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3L44">44</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3L48">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3L49">49</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3L50">50</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3L51">51</a>     <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3L52">52</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3L53">53</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3L54">54</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3L61">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3L62">62</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3L63">63</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3L64">64</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3L65">65</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3L66">66</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3L67">67</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3L68">68</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3L69">69</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3L70">70</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3L71">71</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3L72">72</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/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R12">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R13">13</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R14">14</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R15">15</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R16">16</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R17">17</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R18">18</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R19">19</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R20">20</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R21">21</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R22">22</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R23">23</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R24">24</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R25">25</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R26">26</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R27">27</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R28">28</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R29">29</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R30">30</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R31">31</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R32">32</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R33">33</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R34">34</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R35">35</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R36">36</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R37">37</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R38">38</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R39">39</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R40">40</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R41">41</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R42">42</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R43">43</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R44">44</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R45">45</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R46">46</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R47">47</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R48">48</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R50">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R51">51</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R52">52</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R53">53</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R54">54</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R55">55</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R56">56</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R57">57</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R58">58</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R59">59</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R60">60</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R61">61</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R62">62</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R63">63</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R64">64</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R68">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R69">69</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R70">70</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R71">71</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R72">72</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R73">73</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R74">74</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R75">75</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R76">76</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R83">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R84">84</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R85">85</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R86">86</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R87">87</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R88">88</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R89">89</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R90">90</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R91">91</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R92">92</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R93">93</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R94">94</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-e996d83cfb861feceb0be74b8a646fd3R95">95</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">@@ -13,17 +13,36 @@ PGroongaは内部的に`column LIKE '%キーワード%'`条件を`column %% 'キ たとえば、元の`LIKE`演算子は大文字小文字を区別して検索します。しかし、インデックスを使った`LIKE`演算子は大文字小文字を区別しません。 +Here are sample schema and data: + +```sql +CREATE TABLE memos ( + id integer, + content text +); + +CREATE INDEX pgroonga_content_index ON memos USING pgroonga (content); +``` + +```sql +INSERT INTO memos VALUES (1, 'PostgreSQLはリレーショナル・データベース管理システムです。'); +INSERT INTO memos VALUES (2, 'Groongaは日本語対応の高速な全文検索エンジンです。'); +INSERT INTO memos VALUES (3, 'PGroongaはインデックスとしてGroongaを使うためのPostgreSQLの拡張機能です。'); +INSERT INTO memos VALUES (4, 'groongaコマンドがあります。'); +``` + 元の`LIKE`演算子の結果です。 ```sql SET enable_seqscan = on; SET enable_indexscan = off; SET enable_bitmapscan = off; + SELECT * FROM memos WHERE content LIKE '%groonga%'; -- id | content -- ----+----------------------------- -- 4 | groongaコマンドがあります。 --- (1 行) +-- (1 row) ``` インデックスを使った`LIKE`演算子の結果です。 @@ -32,13 +51,14 @@ SELECT * FROM memos WHERE content LIKE '%groonga%'; SET enable_seqscan = off; SET enable_indexscan = on; SET enable_bitmapscan = on; + SELECT * FROM memos WHERE content LIKE '%groonga%'; -- id | content -- ----+--------------------------------------------------------------------------- -- 2 | Groongaは日本語対応の高速な全文検索エンジンです。 -- 3 | PGroongaはインデックスとしてGroongaを使うためのPostgreSQLの拡張機能です。 -- 4 | groongaコマンドがあります。 --- (3 行) +-- (3 rows) ``` インデックスを使った`LIKE`演算子の結果と元の`LIKE`演算子の結果を同じにしたい場合は次のトークナイザーとノーマライザーを使います。 @@ -49,6 +69,8 @@ SELECT * FROM memos WHERE content LIKE '%groonga%'; 具体例は次の通りです。 ```sql +DROP INDEX IF EXISTS pgroonga_content_index; + CREATE INDEX pgroonga_content_index ON memos USING pgroonga (content) @@ -62,11 +84,12 @@ CREATE INDEX pgroonga_content_index SET enable_seqscan = off; SET enable_indexscan = on; SET enable_bitmapscan = on; + SELECT * FROM memos WHERE content LIKE '%groonga%'; -- id | content -- ----+----------------------------- -- 4 | groongaコマンドがあります。 --- (1 行) +-- (1 row) ``` 通常、デフォルトの設定は元の`LIKE`演算子よりも適切な全文検索結果を返す設定です。もし、デフォルトの設定をするときは、変更する前にユーザーにとてどのような結果が適切かを考えてください。 </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/operators/like.md (+37 -14) =================================================================== </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/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53L12">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53L13">13</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53L14">14</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53L15">15</a>                                     <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53L16">16</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53L17">17</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53L18">18</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53L19">19</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53L20">20</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53L21">21</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53L22">22</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53L23">23</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53L24">24</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53L25">25</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53L26">26</a>         <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53L27">27</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53L28">28</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53L29">29</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53L31">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53L32">32</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53L33">33</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53L34">34</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53L35">35</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53L36">36</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53L37">37</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53L38">38</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53L39">39</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53L40">40</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53L41">41</a>             <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53L42">42</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53L43">43</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53L44">44</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53L48">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53L49">49</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53L50">50</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53L51">51</a>     <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53L52">52</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53L53">53</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53L54">54</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53L61">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53L62">62</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53L63">63</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53L64">64</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53L65">65</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53L66">66</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53L67">67</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53L68">68</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53L69">69</a>         <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53L70">70</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53L71">71</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53L72">72</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/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R12">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R13">13</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R14">14</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R15">15</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R16">16</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R17">17</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R18">18</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R19">19</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R20">20</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R21">21</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R22">22</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R23">23</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R24">24</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R25">25</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R26">26</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R27">27</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R28">28</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R29">29</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R30">30</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R31">31</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R32">32</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R33">33</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R34">34</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R35">35</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R36">36</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R37">37</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R38">38</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R39">39</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R40">40</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R41">41</a>         <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R42">42</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R43">43</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R44">44</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R45">45</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R46">46</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R47">47</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R48">48</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R50">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R51">51</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R52">52</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R53">53</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R54">54</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R55">55</a>             <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R56">56</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R57">57</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R58">58</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R59">59</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R60">60</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R61">61</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R62">62</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R63">63</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R64">64</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R68">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R69">69</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R70">70</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R71">71</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R72">72</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R73">73</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R74">74</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R75">75</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R76">76</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R83">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R84">84</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R85">85</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R86">86</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R87">87</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R88">88</a>         <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R89">89</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R90">90</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R91">91</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R92">92</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R93">93</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R94">94</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/b6e5cdfd4e0a81d0e23773215c65b91770da8668#diff-274aa778ac04b071db2006aec4aa3f53R95">95</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">@@ -13,17 +13,36 @@ The original `LIKE` operator searches against text as is. But `%%` operator does For example, the original `LIKE` operator searches with case sensitive. But `LIKE` operator with index searches with case insensitive. +Here are sample schema and data: + +```sql +CREATE TABLE memos ( + id integer, + content text +); + +CREATE INDEX pgroonga_content_index ON memos USING pgroonga (content); +``` + +```sql +INSERT INTO memos VALUES (1, 'PostgreSQL is a relational database management system.'); +INSERT INTO memos VALUES (2, 'Groonga is a fast full text search engine that supports all languages.'); +INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga as index.'); +INSERT INTO memos VALUES (4, 'There is groonga command.'); +``` + A search result of the original `LIKE` operator: ```sql SET enable_seqscan = on; SET enable_indexscan = off; SET enable_bitmapscan = off; + SELECT * FROM memos WHERE content LIKE '%groonga%'; --- id | content --- ----+----------------------------- --- 4 | groongaコマンドがあります。 --- (1 行) +-- id | content +-- ----+--------------------------- +-- 4 | There is groonga command. +-- (1 row) ``` A search result of `LIKE` operator with index: @@ -32,13 +51,14 @@ A search result of `LIKE` operator with index: SET enable_seqscan = off; SET enable_indexscan = on; SET enable_bitmapscan = on; + SELECT * FROM memos WHERE content LIKE '%groonga%'; --- id | content --- ----+--------------------------------------------------------------------------- --- 2 | Groongaは日本語対応の高速な全文検索エンジンです。 --- 3 | PGroongaはインデックスとしてGroongaを使うためのPostgreSQLの拡張機能です。 --- 4 | groongaコマンドがあります。 --- (3 行) +-- id | content +-- ----+------------------------------------------------------------------------ +-- 2 | Groonga is a fast full text search engine that supports all languages. +-- 3 | PGroonga is a PostgreSQL extension that uses Groonga as index. +-- 4 | There is groonga command. +-- (3 rows) ``` If you want to get the same result by both `LIKE` operator with index and the original `LIKE` operator, use the following tokenizer and normalizer: @@ -49,6 +69,8 @@ If you want to get the same result by both `LIKE` operator with index and the or Here is a concrete example: ```sql +DROP INDEX IF EXISTS pgroonga_content_index; + CREATE INDEX pgroonga_content_index ON memos USING pgroonga (content) @@ -62,11 +84,12 @@ You can get the same result as the original `LIKE` operator with `LIKE` operator SET enable_seqscan = off; SET enable_indexscan = on; SET enable_bitmapscan = on; + SELECT * FROM memos WHERE content LIKE '%groonga%'; --- id | content --- ----+----------------------------- --- 4 | groongaコマンドがあります。 --- (1 行) +-- id | content +-- ----+--------------------------- +-- 4 | There is groonga command. +-- (1 row) ``` Normally, the default configuration returns better result for full text search rather than the original `LIKE` operator. Think about which result is better for users before you change the default configuration. </pre> </td> </tr> </tbody> </table> </div> </body> </html>