<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-2022-jp">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"$B#M#S(B $B%4%7%C%/(B";
panose-1:2 11 6 9 7 2 5 8 2 4;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:"\@$B#M#S(B $B%4%7%C%/(B";
panose-1:2 11 6 9 7 2 5 8 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0mm;
margin-bottom:.0001pt;
text-align:justify;
text-justify:inter-ideograph;
font-size:10.5pt;
font-family:"Arial",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{mso-style-priority:99;
mso-style-link:"$B=q<0$J$7(B \($BJ8;z(B\)";
margin:0mm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"$B#M#S(B $B%4%7%C%/(B";}
span.a
{mso-style-name:"$B=q<0$J$7(B \($BJ8;z(B\)";
mso-style-priority:99;
mso-style-link:$B=q<0$J$7(B;
font-family:"$B#M#S(B $B%4%7%C%/(B";}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Arial",sans-serif;}
/* Page Definitions */
@page WordSection1
{size:612.0pt 792.0pt;
margin:99.25pt 30.0mm 30.0mm 30.0mm;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026">
<v:textbox inset="5.85pt,.7pt,5.85pt,.7pt" />
</o:shapedefaults></xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="JA" link="#0563C1" vlink="#954F72" style="text-justify-trim:punctuation">
<div class="WordSection1">
<p class="MsoPlainText">$B?\F#MM(B<span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText">$B$*@$OC$K$J$C$F$*$j$^$9!#:4F#$G$9!#(B<span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US" style="color:#4472C4">></span><span style="color:#4472C4">$B$J$K$b%R%C%H$7$J$$$h$&$J5$$,$9$k$s$G$9$,!"3NG'$7$?$$$N$G:F8=(B<span lang="EN-US"><o:p></o:p></span></span></p>
<p class="MsoPlainText"><span lang="EN-US" style="color:#4472C4">>SQL</span><span style="color:#4472C4">$B!J(B<span lang="EN-US">CREATE TABLE</span>$B!&(B<span lang="EN-US">CREATE INDEX</span>$B!&(B<span lang="EN-US">INSERT</span>$B!&(B<span lang="EN-US">SELECT</span>$B0l<0!K$rDs6!(B<span lang="EN-US"><o:p></o:p></span></span></p>
<p class="MsoPlainText"><span lang="EN-US" style="color:#4472C4">></span><span style="color:#4472C4">$B$7$F$b$i$($^$;$s$+!)(B<span lang="EN-US"><o:p></o:p></span></span></p>
<p class="MsoPlainText">$B0J2<!"(B<span lang="EN-US">SQL</span>$B$K$J$j$^$9!#(B<span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">----------------------------------------------<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">CREATE SCHEMA sample;<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">CREATE TABLE sample.content ( <o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"> id BIGSERIAL PRIMARY KEY,<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"> document_data TEXT NOT NULL<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">);<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">CREATE INDEX smp_idx ON sample.content USING pgroonga(document_data) WITH (tokenizer='TokenBigramSplitSymbolAlphaDigit');<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">INSERT INTO sample.content (<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">id,document_data<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">)<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">VALUES<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">( '1','</span>$B%F%9%H(B<span lang="EN-US">''.xlsx'<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">);<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">select * from sample.content where document_data &@~(('" "'));<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText">$B0J>e!"$h$m$7$/$*4j$$$$$?$7$^$9!#(B<span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">-----Original Message-----<br>
From: groon****@lists***** [mailto:groon****@lists*****] On Behalf Of Kouhei Sutou<br>
Sent: Wednesday, March 28, 2018 1:46 PM<br>
To: groon****@lists*****<br>
Subject: [groonga-dev,04608] Re: </span>$B1i;;;R(B<span lang="EN-US">&@~ </span>$B;HMQ;~$K6h@Z$jJ8;z$N$_$r(B<span lang="EN-US">""</span>$B$G0O$C$?$H$-$N5sF0$K$D$$$F(B</p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText">$B?\F#$G$9!#(B<span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">In <<a href="mailto:a9660****@MP-MS*****"><span style="color:windowtext;text-decoration:none">a9660****@MP-MS*****</span></a>><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"> "[groonga-dev,04607] </span>$B1i;;;R(B<span lang="EN-US">&@~
</span>$B;HMQ;~$K6h@Z$jJ8;z$N$_$r(B<span lang="EN-US">""</span>$B$G0O$C$?$H$-$N5sF0$K$D$$$F(B<span lang="EN-US">" on Wed, 28 Mar 2018 02:44:15 +0000,<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"> <<a href="mailto:satou****@nttda*****"><span style="color:windowtext;text-decoration:none">satou****@nttda*****</span></a>> wrote:<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">> </span>$B8!:w%-!<%o!<%I!'(B<span lang="EN-US">" "<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">> </span>$B$r8!:w$7$?$H$-$N5sF0$K$D$$$F$G$9!#(B<span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">> </span>$B0J2<$N$h$&$K!"A[Dj(B<span lang="EN-US">/</span>$B<B:]$N5sF0$G0c$$$,$"$j$^$7$?!#(B<span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">> </span>$B$3$l$O;EMM$J$N$+$I$&$+!"$^$?!"$I$N$h$&$J8!:w$r$7$F$$$k$N$+!JH>3Q%9%Z!<%9$,%"%s%I8!:w$H$J$j!"(B<span lang="EN-US">"</span>$B$,@55,2=$5$l(B<span lang="EN-US">'</span>$B$,%R%C%H$7$F$$$k!DEy!K$r65$($FD:$1$J$$$G$7$g$&$+!#(B<span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">> </span>$B$A$J$_$K!"H>3Q%9%Z!<%90J30$G$bA43Q%9%Z!<%9!&%?%V$G$bF1$8$h$&$J5sF0$H$J$j$^$7$?!#(B<span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">> <o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">> </span>$B"#A[Dj5sF0(B<span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">> </span>$B!VH>3Q%9%Z!<%9$r4^$`%+%i%`$,%R%C%H$9$k!W(B<span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">> <o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">> </span>$B"#<B:]$N5sF0(B<span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">> </span>$B!V(B<span lang="EN-US">'</span>$B$r4^$`%+%i%`$,%R%C%H$9$k!W(B<span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText">$B$J$K$b%R%C%H$7$J$$$h$&$J5$$,$9$k$s$G$9$,!"3NG'$7$?$$$N$G:F8=(B<span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">SQL</span>$B!J(B<span lang="EN-US">CREATE TABLE</span>$B!&(B<span lang="EN-US">CREATE INDEX</span>$B!&(B<span lang="EN-US">INSERT</span>$B!&(B<span lang="EN-US">SELECT</span>$B0l<0!K$rDs6!(B<span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoPlainText">$B$7$F$b$i$($^$;$s$+!)(B<span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">-- <o:p></o:p></span></p>
<p class="MsoPlainText">$B?\F#(B $B8yJ?(B<span lang="EN-US"> <<a href="mailto:kou****@clear*****"><span style="color:windowtext;text-decoration:none">kou****@clear*****</span></a>><o:p></o:p></span></p>
<p class="MsoPlainText">$B3t<02q<R%/%j%"%3!<%I(B<span lang="EN-US"> <<a href="http://www.clear-code.com/"><span style="color:windowtext;text-decoration:none">http://www.clear-code.com/</span></a>><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">Groonga</span>$B%Y!<%9$NA4J88!:w%7%9%F%`$rAm9g%5%]!<%H!'(B<span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"> <a href="http://groonga.org/ja/support/">
<span style="color:windowtext;text-decoration:none">http://groonga.org/ja/support/</span></a><o:p></o:p></span></p>
<p class="MsoPlainText">$B%Q%C%A:NMQ(B<span lang="EN-US"> - </span>$B%W%m%0%i%_%s%0$,3Z$7$$?M8~$1$N:NMQ%W%m%;%9!'(B<span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"> <a href="http://www.clear-code.com/recruitment/">
<span style="color:windowtext;text-decoration:none">http://www.clear-code.com/recruitment/</span></a><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">OSS</span>$B3+H/;Y1g%5!<%S%9(B<span lang="EN-US">:<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"> <a href="http://www.clear-code.com/blog/2016/6/27.html">
<span style="color:windowtext;text-decoration:none">http://www.clear-code.com/blog/2016/6/27.html</span></a><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">_______________________________________________<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">groonga-dev mailing list<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><a href="mailto:groon****@lists*****"><span style="color:windowtext;text-decoration:none">groon****@lists*****</span></a><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><a href="https://lists.osdn.me/mailman/listinfo/groonga-dev"><span style="color:windowtext;text-decoration:none">https://lists.osdn.me/mailman/listinfo/groonga-dev</span></a><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US"><o:p> </o:p></span></p>
</div>
</body>
</html>