<!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 21:50:21 +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/c4dfa9c1ae06998db805d53959b606fad3988e1c">c4dfa9c1ae06998db805d53959b606fad3988e1c</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/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903a">_po/ja/reference/functions/pgroonga-command.po</a></li> <li><a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40">ja/reference/functions/pgroonga-command.md</a></li> <li><a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3">reference/functions/pgroonga-command.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/functions/pgroonga-command.po (+78 -42) =================================================================== </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/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903a">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL1">1</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL2">2</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL3">3</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL4">4</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL5">5</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL6">6</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL7">7</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL90">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL91">91</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL92">92</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL93">93</a>                                                         <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL94">94</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL95">95</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL96">96</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL98">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL99">99</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL100">100</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL101">101</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL102">102</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL103">103</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL104">104</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL105">105</a>     <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL106">106</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL107">107</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL108">108</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL109">109</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL110">110</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL111">111</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL112">112</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL113">113</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL114">114</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL115">115</a>                   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL116">116</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL117">117</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL118">118</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL120">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL121">121</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL122">122</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL123">123</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL124">124</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL125">125</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL126">126</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL127">127</a>     <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL128">128</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL129">129</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL130">130</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL138">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL139">139</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL140">140</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL141">141</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL142">142</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL143">143</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL144">144</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL145">145</a>     <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL146">146</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL147">147</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL148">148</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL149">149</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL150">150</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL151">151</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL152">152</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL153">153</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL154">154</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL155">155</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL156">156</a>                       <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL157">157</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL158">158</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL159">159</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL160">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL161">161</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL162">162</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL163">163</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL164">164</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL165">165</a>     <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL166">166</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL167">167</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL168">168</a>     <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL169">169</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL170">170</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL171">171</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL172">172</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL173">173</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL174">174</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL175">175</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL176">176</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL177">177</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL178">178</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL179">179</a>     <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL180">180</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL181">181</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL182">182</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL183">183</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL184">184</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL185">185</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL186">186</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL187">187</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL188">188</a>                   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL189">189</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL190">190</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aL191">191</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/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903a">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR1">1</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR2">2</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR3">3</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR4">4</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR5">5</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR6">6</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR7">7</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR90">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR91">91</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR92">92</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR93">93</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR94">94</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR95">95</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR96">96</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR97">97</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR98">98</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR99">99</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR100">100</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR101">101</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR102">102</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR103">103</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR104">104</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR105">105</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR106">106</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR107">107</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR108">108</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR109">109</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR110">110</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR111">111</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR112">112</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR113">113</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR114">114</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR115">115</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR116">116</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR117">117</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR118">118</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR119">119</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR120">120</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR121">121</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR122">122</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR123">123</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR124">124</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR126">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR127">127</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR128">128</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR129">129</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR130">130</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR131">131</a>     <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR132">132</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR133">133</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR134">134</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR135">135</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR136">136</a>               <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR137">137</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR138">138</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR139">139</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR140">140</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR141">141</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR142">142</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR143">143</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR144">144</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR145">145</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR146">146</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR147">147</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR148">148</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR150">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR151">151</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR152">152</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR153">153</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR154">154</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR155">155</a>     <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR156">156</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR157">157</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR158">158</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR159">159</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR160">160</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR168">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR169">169</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR170">170</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR171">171</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR172">172</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR173">173</a>     <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR174">174</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR175">175</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR176">176</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR177">177</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR178">178</a>                 <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR179">179</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR180">180</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR181">181</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR182">182</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR183">183</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR184">184</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR185">185</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR186">186</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR187">187</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR188">188</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR189">189</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR190">190</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR191">191</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR192">192</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR193">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR194">194</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR195">195</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR196">196</a>     <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR197">197</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR198">198</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR199">199</a>     <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR200">200</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR201">201</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR202">202</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR203">203</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR204">204</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR205">205</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR206">206</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR207">207</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR208">208</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR209">209</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR210">210</a>     <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR211">211</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR212">212</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR213">213</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR214">214</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR215">215</a>             <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR216">216</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR217">217</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR218">218</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR219">219</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR220">220</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR221">221</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR222">222</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR223">223</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR224">224</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR225">225</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR226">226</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-2ad9999b1dffd4bc0a93925a51ba903aR227">227</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-25 21:03+0900\n" +"PO-Revision-Date: 2015-10-25 21:49+0900\n" "Language: ja\n" "MIME-Version: 1.0\n" "Content-Type: text/plain; charset=UTF-8\n" @@ -91,6 +91,34 @@ msgstr "" msgid "The followings show this case by example." msgstr "このケースを例で説明します。" +msgid "Here are sample schema and data for examples:" +msgstr "例に使うサンプルスキーマとデータは次の通りです。" + +msgid "" +"```sql\n" +"CREATE TABLE posts (\n" +" id integer PRIMARY KEY,\n" +" title text,\n" +" content text\n" +");" +msgstr "" + +msgid "" +"CREATE INDEX pgroonga_posts_index\n" +" ON posts\n" +" USING pgroonga (id, title, content);" +msgstr "" + +msgid "" +"INSERT INTO posts VALUES (1, 'PostgreSQL', 'PostgreSQL is a relational databas" +"e management system.');\n" +"INSERT INTO posts VALUES (2, 'Groonga', 'Groonga is a fast full text search en" +"gine that supports all languages.');\n" +"INSERT INTO posts VALUES (3, 'PGroonga', 'PGroonga is a PostgreSQL extension t" +"hat uses Groonga as index.');\n" +"```" +msgstr "" + msgid "Here is the result before updating. There are 3 records:" msgstr "以下は更新前の結果です。3レコードあります。" @@ -99,20 +127,22 @@ msgid "" "SELECT *\n" " FROM json_array_elements(\n" " pgroonga.command('select ' ||\n" -" pgroonga.table_name('pgroonga_terms_index')\n" +" pgroonga.table_name('pgroonga_posts_index')\n" " )::json->1->0);\n" -"-- value " -" \n" +"-- value " +" \n" "-- ---------------------------------------------------------------------------" -"--------------------------------\n" +"----------------------\n" "-- [3]\n" -"-- [[\"_id\",\"UInt32\"],[\"_key\",\"UInt64\"],[\"content\",\"LongText\"],[\"tag\",\"ShortTe" -"xt\"],[\"title\",\"LongText\"]]\n" -"-- [1,1,\"PostgreSQLはリレーショナル・データベース管理システムです。\",\"PostgreSQL\",\"PostgreSQL\"]\n" -"-- [2,2,\"Groongaは日本語対応の高速な全文検索エンジンです。\",\"Groonga\",\"Groonga\"]\n" -"-- [3,3,\"PGroongaはインデックスとしてGroongaを使うためのPostgreSQLの拡張機能です。\",\"PostgreSQL\",\"PGr" -"oonga\"]\n" -"-- (5 行)\n" +"-- [[\"_id\",\"UInt32\"],[\"content\",\"LongText\"],[\"ctid\",\"UInt64\"],[\"id\",\"Int32\"]," +"[\"title\",\"LongText\"]]\n" +"-- [1,\"PostgreSQL is a relational database management system.\",1,1,\"PostgreSQ" +"L\"]\n" +"-- [2,\"Groonga is a fast full text search engine that supports all languages." +"\",2,2,\"Groonga\"]\n" +"-- [3,\"PGroonga is a PostgreSQL extension that uses Groonga as index.\",3,3,\"P" +"Groonga\"]\n" +"-- (5 rows)\n" "```" msgstr "" @@ -121,10 +151,10 @@ msgstr "1つのレコードを更新します。" msgid "" "```sql\n" -"UPDATE terms\n" +"UPDATE posts\n" " SET title = 'Mroonga',\n" -" content = 'MroongaはGroongaをバックエンドにしたMySQLのストレージエンジンです。',\n" -" tag = 'MySQL'\n" +" content = 'Mroonga is a MySQL storage engine that uses Groonga as backe" +"nd.'\n" " WHERE id = 3;\n" "```" msgstr "" @@ -139,21 +169,24 @@ msgid "" "SELECT *\n" " FROM json_array_elements(\n" " pgroonga.command('select ' ||\n" -" pgroonga.table_name('pgroonga_terms_index')\n" +" pgroonga.table_name('pgroonga_posts_index')\n" " )::json->1->0);\n" -"-- value " -" \n" +"-- value " +" \n" "-- ---------------------------------------------------------------------------" -"--------------------------------\n" +"----------------------\n" "-- [4]\n" -"-- [[\"_id\",\"UInt32\"],[\"_key\",\"UInt64\"],[\"content\",\"LongText\"],[\"tag\",\"ShortTe" -"xt\"],[\"title\",\"LongText\"]]\n" -"-- [1,1,\"PostgreSQLはリレーショナル・データベース管理システムです。\",\"PostgreSQL\",\"PostgreSQL\"]\n" -"-- [2,2,\"Groongaは日本語対応の高速な全文検索エンジンです。\",\"Groonga\",\"Groonga\"]\n" -"-- [3,3,\"PGroongaはインデックスとしてGroongaを使うためのPostgreSQLの拡張機能です。\",\"PostgreSQL\",\"PGr" -"oonga\"]\n" -"-- [4,4,\"MroongaはGroongaをバックエンドにしたMySQLのストレージエンジンです。\",\"MySQL\",\"Mroonga\"]\n" -"-- (6 行)\n" +"-- [[\"_id\",\"UInt32\"],[\"content\",\"LongText\"],[\"ctid\",\"UInt64\"],[\"id\",\"Int32\"]," +"[\"title\",\"LongText\"]]\n" +"-- [1,\"PostgreSQL is a relational database management system.\",1,1,\"PostgreSQ" +"L\"]\n" +"-- [2,\"Groonga is a fast full text search engine that supports all languages." +"\",2,2,\"Groonga\"]\n" +"-- [3,\"PGroonga is a PostgreSQL extension that uses Groonga as index.\",3,3,\"P" +"Groonga\"]\n" +"-- [4,\"Mroonga is a MySQL storage engine that uses Groonga as backend.\",4,3,\"" +"Mroonga\"]\n" +"-- (6 rows)\n" "```" msgstr "" @@ -161,31 +194,34 @@ msgid "The old record is deleted when `VACUUM` is executed." msgstr "古いレコードは`VACUUM`実行時に削除されます。" msgid "" -"Execute `VACUUM` explicitly. And then execute `select` Groonga command again. " -"It returns 3 records. There isn't the old record:" +"Execute `VACUUM FULL` explicitly. And then execute `select` Groonga command ag" +"ain. It returns 3 records. There isn't the old record:" msgstr "" -"明示的に`VACUUM`を実行します。その後、Groongaの`select`コマンドを再度実行します。3レコード返ってきます。ここには古いレコードはありま" -"せん。" +"明示的に`VACUUM FULL`を実行します。その後、Groongaの`select`コマンドを再度実行します。3レコード返ってきます。ここには古いレコー" +"ドはありません。" msgid "" "```sql\n" -"VACUUM;\n" +"VACUUM FULL;\n" "SELECT *\n" " FROM json_array_elements(\n" " pgroonga.command('select ' ||\n" -" pgroonga.table_name('pgroonga_terms_index')\n" +" pgroonga.table_name('pgroonga_posts_index')\n" " )::json->1->0);\n" -"-- value " -" \n" +"-- value " +" \n" "-- ---------------------------------------------------------------------------" -"---------------------------\n" +"----------------------\n" "-- [3]\n" -"-- [[\"_id\",\"UInt32\"],[\"_key\",\"UInt64\"],[\"content\",\"LongText\"],[\"tag\",\"ShortTe" -"xt\"],[\"title\",\"LongText\"]]\n" -"-- [1,1,\"PostgreSQLはリレーショナル・データベース管理システムです。\",\"PostgreSQL\",\"PostgreSQL\"]\n" -"-- [2,2,\"Groongaは日本語対応の高速な全文検索エンジンです。\",\"Groonga\",\"Groonga\"]\n" -"-- [4,4,\"MroongaはGroongaをバックエンドにしたMySQLのストレージエンジンです。\",\"MySQL\",\"Mroonga\"]\n" -"-- (5 行)\n" +"-- [[\"_id\",\"UInt32\"],[\"content\",\"LongText\"],[\"ctid\",\"UInt64\"],[\"id\",\"Int32\"]," +"[\"title\",\"LongText\"]]\n" +"-- [1,\"PostgreSQL is a relational database management system.\",1,1,\"PostgreSQ" +"L\"]\n" +"-- [2,\"Groonga is a fast full text search engine that supports all languages." +"\",2,2,\"Groonga\"]\n" +"-- [3,\"Mroonga is a MySQL storage engine that uses Groonga as backend.\",3,3,\"" +"Mroonga\"]\n" +"-- (5 rows)\n" "```" msgstr "" </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/functions/pgroonga-command.md (+47 -30) =================================================================== </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/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L34">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L35">35</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L36">36</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L37">37</a>                                     <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L38">38</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L39">39</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L40">40</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L41">41</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L42">42</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L43">43</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L44">44</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L45">45</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L46">46</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L47">47</a>     <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L48">48</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L49">49</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L50">50</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L51">51</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L52">52</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L53">53</a>           <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L54">54</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L55">55</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L56">56</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L57">57</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L58">58</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L59">59</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L60">60</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L61">61</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L62">62</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L63">63</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L64">64</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L65">65</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L68">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L69">69</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L70">70</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L71">71</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L72">72</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L73">73</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L74">74</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L75">75</a>     <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L76">76</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L77">77</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L78">78</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L79">79</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L80">80</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L81">81</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L82">82</a>             <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L83">83</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L84">84</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L85">85</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L86">86</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L87">87</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L88">88</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L89">89</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L90">90</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L91">91</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L92">92</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L93">93</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L94">94</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L95">95</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L96">96</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L97">97</a>     <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L98">98</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L99">99</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L100">100</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L101">101</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L102">102</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L103">103</a>           <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L104">104</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L105">105</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40L106">106</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/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R34">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R35">35</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R36">36</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R37">37</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R38">38</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R39">39</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R40">40</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R41">41</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R42">42</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R43">43</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R44">44</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R45">45</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R46">46</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R47">47</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R48">48</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R49">49</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R50">50</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R51">51</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R52">52</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R53">53</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R54">54</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R55">55</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R56">56</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R57">57</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R58">58</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R59">59</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R60">60</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R61">61</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R62">62</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R63">63</a>     <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R64">64</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R65">65</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R66">66</a>           <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R67">67</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R68">68</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R69">69</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R70">70</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R71">71</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R72">72</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R73">73</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R74">74</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R75">75</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R76">76</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R77">77</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R78">78</a>     <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R79">79</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R80">80</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R81">81</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R82">82</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R85">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R86">86</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R87">87</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R88">88</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R89">89</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R90">90</a>     <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R91">91</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R92">92</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R93">93</a>             <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R94">94</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R95">95</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R96">96</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R97">97</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R98">98</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R99">99</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R100">100</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R101">101</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R102">102</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R103">103</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R104">104</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R105">105</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R106">106</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R107">107</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R108">108</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R109">109</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R110">110</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R111">111</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R112">112</a>     <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R113">113</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R114">114</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R115">115</a>           <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R116">116</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R117">117</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R118">118</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R119">119</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R120">120</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R121">121</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R122">122</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-08aea30ea4ed298bfcd36f553f989e40R123">123</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">@@ -35,31 +35,48 @@ Groongaのコマンドは結果をJSONとして返します。`pgroonga.command` このケースを例で説明します。 +例に使うサンプルスキーマとデータは次の通りです。 + +```sql +CREATE TABLE posts ( + id integer PRIMARY KEY, + title text, + content text +); + +CREATE INDEX pgroonga_posts_index + ON posts + USING pgroonga (id, title, content); + +INSERT INTO posts VALUES (1, 'PostgreSQL', 'PostgreSQL is a relational database management system.'); +INSERT INTO posts VALUES (2, 'Groonga', 'Groonga is a fast full text search engine that supports all languages.'); +INSERT INTO posts VALUES (3, 'PGroonga', 'PGroonga is a PostgreSQL extension that uses Groonga as index.'); +``` + 以下は更新前の結果です。3レコードあります。 ```sql SELECT * FROM json_array_elements( pgroonga.command('select ' || - pgroonga.table_name('pgroonga_terms_index') + pgroonga.table_name('pgroonga_posts_index') )::json->1->0); --- value --- ----------------------------------------------------------------------------------------------------------- +-- value +-- ------------------------------------------------------------------------------------------------- -- [3] --- [["_id","UInt32"],["_key","UInt64"],["content","LongText"],["tag","ShortText"],["title","LongText"]] --- [1,1,"PostgreSQLはリレーショナル・データベース管理システムです。","PostgreSQL","PostgreSQL"] --- [2,2,"Groongaは日本語対応の高速な全文検索エンジンです。","Groonga","Groonga"] --- [3,3,"PGroongaはインデックスとしてGroongaを使うためのPostgreSQLの拡張機能です。","PostgreSQL","PGroonga"] --- (5 行) +-- [["_id","UInt32"],["content","LongText"],["ctid","UInt64"],["id","Int32"],["title","LongText"]] +-- [1,"PostgreSQL is a relational database management system.",1,1,"PostgreSQL"] +-- [2,"Groonga is a fast full text search engine that supports all languages.",2,2,"Groonga"] +-- [3,"PGroonga is a PostgreSQL extension that uses Groonga as index.",3,3,"PGroonga"] +-- (5 rows) ``` 1つのレコードを更新します。 ```sql -UPDATE terms +UPDATE posts SET title = 'Mroonga', - content = 'MroongaはGroongaをバックエンドにしたMySQLのストレージエンジンです。', - tag = 'MySQL' + content = 'Mroonga is a MySQL storage engine that uses Groonga as backend.' WHERE id = 3; ``` @@ -69,38 +86,38 @@ Groongaの`select`コマンドを再度実行します。4レコード返りま SELECT * FROM json_array_elements( pgroonga.command('select ' || - pgroonga.table_name('pgroonga_terms_index') + pgroonga.table_name('pgroonga_posts_index') )::json->1->0); --- value --- ----------------------------------------------------------------------------------------------------------- +-- value +-- ------------------------------------------------------------------------------------------------- -- [4] --- [["_id","UInt32"],["_key","UInt64"],["content","LongText"],["tag","ShortText"],["title","LongText"]] --- [1,1,"PostgreSQLはリレーショナル・データベース管理システムです。","PostgreSQL","PostgreSQL"] --- [2,2,"Groongaは日本語対応の高速な全文検索エンジンです。","Groonga","Groonga"] --- [3,3,"PGroongaはインデックスとしてGroongaを使うためのPostgreSQLの拡張機能です。","PostgreSQL","PGroonga"] --- [4,4,"MroongaはGroongaをバックエンドにしたMySQLのストレージエンジンです。","MySQL","Mroonga"] --- (6 行) +-- [["_id","UInt32"],["content","LongText"],["ctid","UInt64"],["id","Int32"],["title","LongText"]] +-- [1,"PostgreSQL is a relational database management system.",1,1,"PostgreSQL"] +-- [2,"Groonga is a fast full text search engine that supports all languages.",2,2,"Groonga"] +-- [3,"PGroonga is a PostgreSQL extension that uses Groonga as index.",3,3,"PGroonga"] +-- [4,"Mroonga is a MySQL storage engine that uses Groonga as backend.",4,3,"Mroonga"] +-- (6 rows) ``` 古いレコードは`VACUUM`実行時に削除されます。 -明示的に`VACUUM`を実行します。その後、Groongaの`select`コマンドを再度実行します。3レコード返ってきます。ここには古いレコードはありません。 +明示的に`VACUUM FULL`を実行します。その後、Groongaの`select`コマンドを再度実行します。3レコード返ってきます。ここには古いレコードはありません。 ```sql -VACUUM; +VACUUM FULL; SELECT * FROM json_array_elements( pgroonga.command('select ' || - pgroonga.table_name('pgroonga_terms_index') + pgroonga.table_name('pgroonga_posts_index') )::json->1->0); --- value --- ------------------------------------------------------------------------------------------------------ +-- value +-- ------------------------------------------------------------------------------------------------- -- [3] --- [["_id","UInt32"],["_key","UInt64"],["content","LongText"],["tag","ShortText"],["title","LongText"]] --- [1,1,"PostgreSQLはリレーショナル・データベース管理システムです。","PostgreSQL","PostgreSQL"] --- [2,2,"Groongaは日本語対応の高速な全文検索エンジンです。","Groonga","Groonga"] --- [4,4,"MroongaはGroongaをバックエンドにしたMySQLのストレージエンジンです。","MySQL","Mroonga"] --- (5 行) +-- [["_id","UInt32"],["content","LongText"],["ctid","UInt64"],["id","Int32"],["title","LongText"]] +-- [1,"PostgreSQL is a relational database management system.",1,1,"PostgreSQL"] +-- [2,"Groonga is a fast full text search engine that supports all languages.",2,2,"Groonga"] +-- [3,"Mroonga is a MySQL storage engine that uses Groonga as backend.",3,3,"Mroonga"] +-- (5 rows) ``` ## 参考 </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/functions/pgroonga-command.md (+47 -30) =================================================================== </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/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L34">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L35">35</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L36">36</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L37">37</a>                                     <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L38">38</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L39">39</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L40">40</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L41">41</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L42">42</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L43">43</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L44">44</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L45">45</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L46">46</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L47">47</a>     <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L48">48</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L49">49</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L50">50</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L51">51</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L52">52</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L53">53</a>           <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L54">54</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L55">55</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L56">56</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L57">57</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L58">58</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L59">59</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L60">60</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L61">61</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L62">62</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L63">63</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L64">64</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L65">65</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L68">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L69">69</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L70">70</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L71">71</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L72">72</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L73">73</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L74">74</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L75">75</a>     <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L76">76</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L77">77</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L78">78</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L79">79</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L80">80</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L81">81</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L82">82</a>             <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L83">83</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L84">84</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L85">85</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L86">86</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L87">87</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L88">88</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L89">89</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L90">90</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L91">91</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L92">92</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L93">93</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L94">94</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L95">95</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L96">96</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L97">97</a>     <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L98">98</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L99">99</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L100">100</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L101">101</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L102">102</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L103">103</a>           <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L104">104</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L105">105</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3L106">106</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/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R34">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R35">35</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R36">36</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R37">37</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R38">38</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R39">39</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R40">40</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R41">41</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R42">42</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R43">43</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R44">44</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R45">45</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R46">46</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R47">47</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R48">48</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R49">49</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R50">50</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R51">51</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R52">52</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R53">53</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R54">54</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R55">55</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R56">56</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R57">57</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R58">58</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R59">59</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R60">60</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R61">61</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R62">62</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R63">63</a>     <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R64">64</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R65">65</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R66">66</a>           <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R67">67</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R68">68</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R69">69</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R70">70</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R71">71</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R72">72</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R73">73</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R74">74</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R75">75</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R76">76</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R77">77</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R78">78</a>     <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R79">79</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R80">80</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R81">81</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R82">82</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R85">...</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R86">86</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R87">87</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R88">88</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R89">89</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R90">90</a>     <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R91">91</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R92">92</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R93">93</a>             <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R94">94</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R95">95</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R96">96</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R97">97</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R98">98</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R99">99</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R100">100</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R101">101</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R102">102</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R103">103</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R104">104</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R105">105</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R106">106</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R107">107</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R108">108</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R109">109</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R110">110</a>   <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R111">111</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R112">112</a>     <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R113">113</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R114">114</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R115">115</a>           <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R116">116</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R117">117</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R118">118</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R119">119</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R120">120</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R121">121</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R122">122</a> <a href="https://github.com/pgroonga/pgroonga.github.io/commit/c4dfa9c1ae06998db805d53959b606fad3988e1c#diff-847a8238763e7f52d527bcbd182e1dc3R123">123</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">@@ -35,31 +35,48 @@ You may get invalid records when PGroonga index target table processed one or mo The followings show this case by example. +Here are sample schema and data for examples: + +```sql +CREATE TABLE posts ( + id integer PRIMARY KEY, + title text, + content text +); + +CREATE INDEX pgroonga_posts_index + ON posts + USING pgroonga (id, title, content); + +INSERT INTO posts VALUES (1, 'PostgreSQL', 'PostgreSQL is a relational database management system.'); +INSERT INTO posts VALUES (2, 'Groonga', 'Groonga is a fast full text search engine that supports all languages.'); +INSERT INTO posts VALUES (3, 'PGroonga', 'PGroonga is a PostgreSQL extension that uses Groonga as index.'); +``` + Here is the result before updating. There are 3 records: ```sql SELECT * FROM json_array_elements( pgroonga.command('select ' || - pgroonga.table_name('pgroonga_terms_index') + pgroonga.table_name('pgroonga_posts_index') )::json->1->0); --- value --- ----------------------------------------------------------------------------------------------------------- +-- value +-- ------------------------------------------------------------------------------------------------- -- [3] --- [["_id","UInt32"],["_key","UInt64"],["content","LongText"],["tag","ShortText"],["title","LongText"]] --- [1,1,"PostgreSQLはリレーショナル・データベース管理システムです。","PostgreSQL","PostgreSQL"] --- [2,2,"Groongaは日本語対応の高速な全文検索エンジンです。","Groonga","Groonga"] --- [3,3,"PGroongaはインデックスとしてGroongaを使うためのPostgreSQLの拡張機能です。","PostgreSQL","PGroonga"] --- (5 行) +-- [["_id","UInt32"],["content","LongText"],["ctid","UInt64"],["id","Int32"],["title","LongText"]] +-- [1,"PostgreSQL is a relational database management system.",1,1,"PostgreSQL"] +-- [2,"Groonga is a fast full text search engine that supports all languages.",2,2,"Groonga"] +-- [3,"PGroonga is a PostgreSQL extension that uses Groonga as index.",3,3,"PGroonga"] +-- (5 rows) ``` Update 1 record: ```sql -UPDATE terms +UPDATE posts SET title = 'Mroonga', - content = 'MroongaはGroongaをバックエンドにしたMySQLのストレージエンジンです。', - tag = 'MySQL' + content = 'Mroonga is a MySQL storage engine that uses Groonga as backend.' WHERE id = 3; ``` @@ -69,38 +86,38 @@ Executes `select` Groonga command again. It returns 4 records. 1 record is added SELECT * FROM json_array_elements( pgroonga.command('select ' || - pgroonga.table_name('pgroonga_terms_index') + pgroonga.table_name('pgroonga_posts_index') )::json->1->0); --- value --- ----------------------------------------------------------------------------------------------------------- +-- value +-- ------------------------------------------------------------------------------------------------- -- [4] --- [["_id","UInt32"],["_key","UInt64"],["content","LongText"],["tag","ShortText"],["title","LongText"]] --- [1,1,"PostgreSQLはリレーショナル・データベース管理システムです。","PostgreSQL","PostgreSQL"] --- [2,2,"Groongaは日本語対応の高速な全文検索エンジンです。","Groonga","Groonga"] --- [3,3,"PGroongaはインデックスとしてGroongaを使うためのPostgreSQLの拡張機能です。","PostgreSQL","PGroonga"] --- [4,4,"MroongaはGroongaをバックエンドにしたMySQLのストレージエンジンです。","MySQL","Mroonga"] --- (6 行) +-- [["_id","UInt32"],["content","LongText"],["ctid","UInt64"],["id","Int32"],["title","LongText"]] +-- [1,"PostgreSQL is a relational database management system.",1,1,"PostgreSQL"] +-- [2,"Groonga is a fast full text search engine that supports all languages.",2,2,"Groonga"] +-- [3,"PGroonga is a PostgreSQL extension that uses Groonga as index.",3,3,"PGroonga"] +-- [4,"Mroonga is a MySQL storage engine that uses Groonga as backend.",4,3,"Mroonga"] +-- (6 rows) ``` The old record is deleted when `VACUUM` is executed. -Execute `VACUUM` explicitly. And then execute `select` Groonga command again. It returns 3 records. There isn't the old record: +Execute `VACUUM FULL` explicitly. And then execute `select` Groonga command again. It returns 3 records. There isn't the old record: ```sql -VACUUM; +VACUUM FULL; SELECT * FROM json_array_elements( pgroonga.command('select ' || - pgroonga.table_name('pgroonga_terms_index') + pgroonga.table_name('pgroonga_posts_index') )::json->1->0); --- value --- ------------------------------------------------------------------------------------------------------ +-- value +-- ------------------------------------------------------------------------------------------------- -- [3] --- [["_id","UInt32"],["_key","UInt64"],["content","LongText"],["tag","ShortText"],["title","LongText"]] --- [1,1,"PostgreSQLはリレーショナル・データベース管理システムです。","PostgreSQL","PostgreSQL"] --- [2,2,"Groongaは日本語対応の高速な全文検索エンジンです。","Groonga","Groonga"] --- [4,4,"MroongaはGroongaをバックエンドにしたMySQLのストレージエンジンです。","MySQL","Mroonga"] --- (5 行) +-- [["_id","UInt32"],["content","LongText"],["ctid","UInt64"],["id","Int32"],["title","LongText"]] +-- [1,"PostgreSQL is a relational database management system.",1,1,"PostgreSQL"] +-- [2,"Groonga is a fast full text search engine that supports all languages.",2,2,"Groonga"] +-- [3,"Mroonga is a MySQL storage engine that uses Groonga as backend.",3,3,"Mroonga"] +-- (5 rows) ``` ## See also </pre> </td> </tr> </tbody> </table> </div> </body> </html>