tak_kaz24****@yahoo*****
tak_kaz24****@yahoo*****
2017年 2月 22日 (水) 16:19:14 JST
$B$*@$OC$K$J$C$F$$$^$9!#9b66$H?=$7$^$9!#(B PGroonga$B$N(BWindows$BHG$r;HMQ$7$FA4J88!:w%7%9%F%`$r9=C[$9$Y$/F0:n8!>Z$r$7$F$*$j$^$9!#(B $B?t;z7A<0$NA0J}0lCW8!:w$K$D$$$F0J2<$N$h$&$J;v>]$,H/@8$7$F$$$^$9$N$G!"(B $B$*<j?t$G$9$,2sEz4j$($^$9$G$7$g$&$+!#(B $B"#4D6-(B Windows Server 2008 R2 Standard SP1$B!J(B64bit$B!K(B PostgreSQL9.5.5-1$B!J(BWindows$B%$%s%9%H!<%iHG;HMQ!K(B pgroonga1.1.9$B!J(BWindows$B%P%$%J%jHG;HMQ!K(B $B"#;v>](B $B?t;z7A<0$N%G!<%?$r%F!<%V%k$K3JG<$7(BSQL$B$rH/9T$7$?$H$3$m!"(B $BA0J}0lCW$G3:Ev$9$k>l9g$H3:Ev$7$J$$>l9g$,$"$j$^$9!#(B $BFC$K(BPostgreSQL$B$d(Bpgroonga$B$N%m%0$K%(%i!<$O=PNO$5$l$F$$$^$;$s!#(B $B"#<B:]$N%F!<%V%k!"%G!<%?(B CREATE TABLE memos ( id integer, content text ); CREATE INDEX pgroonga_content_index ON memos USING pgroonga (content); $B"(%G%U%)%k%H$N(BTokenBigram$B!"(BNormalizerAuto$B$N4D6-(B INSERT INTO memos VALUES (1, '123'); INSERT INTO memos VALUES (2, '12345'); INSERT INTO memos VALUES (3, '1234567890'); $B"#(BSQL$B<B9T;~$N7k2L(B $B0J2<$N$h$&$J(BSQL$B$G-!!A-&$N$h$&$J%Q%?!<%s$G8!:w$r<B;\(B SELECT id FROM memos WHERE content %% '123' $B-!(Bcontent$B$r(B1$B$G8!:w"*(Bid1$B!"(B2$B!"(B3$B$,8!:w$K3:Ev(B $B-"(Bcontent$B$r(B12$B$G8!:w"*(Bid1$B!"(B2$B!"(B3$B$,8!:w$K3:Ev(B $B-#(Bcontent$B$r(B123$B$G8!:w"*(Bid1$B$,8!:w$K3:Ev(B $B-$(Bcontent$B$r(B1234$B$G8!:w"*(Bid2$B!"(B3$B$,8!:w$K3:Ev(B $B-%(Bcontent$B$r(B12345$B$G8!:w"*(Bid2$B$,8!:w$K3:Ev(B $B-&(Bcontent$B$r(B123456$B$G8!:w"*(Bid3$B$,8!:w$K3:Ev(B $B"(0J2<(B1234567890$B$^$G7e$rA}$d$7$F$$$/>l9g$b(Bid3$B$,8!:w$K3:Ev(B $B"#A[Dj7k2L(B $B0J2<$N$h$&$J8!:w7k2L$K$J$kA[Dj$G$7$?!#(B $B-#(Bcontent$B$r(B123$B$G8!:w"*(Bid1$B!"(B2$B!"(B3$B$,8!:w$K3:Ev(B $B-%(Bcontent$B$r(B12345$B$G8!:w"*(Bid2$B!"(B3$B$,8!:w$K3:Ev(B $BA0J}0lCW!"Cf4V0lCW!"8eJ}0lCW$K4X$7$F0J2<$N$h$&$JA[Dj$G$7$?$,!"(B $B?t;z$NA0J}0lCW$K4X$7$F$O(BSQL$B$N7k2L$+$i8!:w$K3:Ev$9$k>l9g$H3:Ev$7$J$$>l9g$,$"$j!"(B $B$P$i$D$-$,$"$k$h$&$K8+<u$1$i$l$^$9$N$G$*<j?t$G$9$,;EMM$r$465<(4j$($^$9$G$7$g$&$+!#(B $B!&1Q;z!"?t;z!'A0J}0lCW$N$_2DG=$GCf4V0lCW!"8eJ}0lCW$O=PMh$J$$(B $B!&$R$i$,$J!"%+%?%+%J!"4A;z!"5-9f!'A0J}0lCW!"Cf4V0lCW!"8eJ}0lCW2DG=(B
