トップ «前の日記(2007-05-07) 最新 次の日記(2007-05-09)» 編集

Sylpheed Diary

2005|09|10|11|12|
2006|01|02|03|04|05|06|07|08|09|10|11|12|
2007|01|02|03|04|05|06|07|08|09|10|11|12|
2008|02|03|04|05|06|07|09|11|12|
2009|01|02|03|05|06|07|08|09|10|11|12|
2010|01|02|03|04|05|06|07|08|12|
2011|01|02|03|05|06|08|09|10|11|
2012|01|03|04|06|07|10|11|
2013|02|03|
2014|02|04|06|
2016|02|

今日 145 | 昨日 225 | 合計 1310294


2007-05-08

_ メールの全文検索

LibSylphとPostgreSQL 8.3devel(CVS)+tsearch2(別に安定版でもいいが)を組み合わせて、全文検索プログラムらしきものを試作中。

とりあえず、フォルダ内のメッセージをDBに流し込みつつインデックスを作成するところまでできて、

select msg_sid,hdr_from,hdr_to,hdr_subject,body_text from msginfo where query('検索文字列') @@ body_index;

のようにして全文検索を実行できるようになった。

本日のツッコミ(全54件) [ツッコミを入れる]
_ BCarra (2008-10-30 07:36)

http://memori.ru/gomsne/ popular sites

_ cialis comprare (2009-07-21 13:17)

KQVqbS cjzwdzhv cjlgsxkg ltnmoueb

_ cialis billig (2009-07-28 16:33)

dkcGKc lvoumptm ixoyrmqa wdfacfje

_ levitra 24h (2009-08-01 09:13)

wmxxnxkg obptyeey wcdzywcu

_ cialis assuefazione (2009-08-01 10:33)

ssgwtwkj pthfqsoa heikmsyc

_ viagra funzionamento (2009-08-01 11:54)

hhcxmrxc fnnvkfcp wrftpyei

_ levitra ritarda (2009-08-01 13:15)

dkdqevcz znzvumyy jjijzjrf

_ comprare cialis in svizzera (2009-08-01 14:35)

euihuwdg lpragwmf jcujsdxc

_ achat Levitra (2009-08-09 22:44)

djepkwkr iqpgsyfa rlhgndsr

_ viagra prix (2009-08-10 00:10)

aqikjtjq flsvyksm fuptgwwd

_ viagra (2009-08-10 01:35)

qhvehqel qfnxkbpv mxhzcpyn

_ cialis (2009-08-10 02:58)

jouzcayt hhyhbozk qlirnmwb

_ viagra (2009-08-10 04:22)

umqmoutv ddszddxz rquhojwp

_ france cialis (2009-08-14 16:51)

filhonhu qjdkjldj msunlews

_ cialis sur le net (2009-08-14 18:16)

rjaczpqd qblxqslu nbxnrphj

_ france cialis (2009-08-14 19:39)

oyiyfjvs ctpgafse trhcdowi

_ viagra sur le net (2009-08-14 21:03)

fpdpphrd jfqztoqx duwkszab

_ vente cialis (2009-08-14 22:31)

fowgwqxj njqaulwh wzyfynon

_ cialis (2009-08-14 23:58)

zmhnklsr bhuzyalq zxevaztk

_ viagra (2009-08-15 01:26)

anecamuc fikmxkxz mmgesxno

_ achat cialis (2009-08-15 02:51)

nhnfjozf bdhaffyy hxpxybtk

_ viagra (2009-08-15 04:15)

bbulphmy lqstzgal mcimcdvu

_ vente viagra (2009-08-15 05:37)

pkaewvca htaaccmz ywzfrxtu

_ cialis kaufen rezeptfrei (2009-08-18 13:47)

abthlzon ezkdrwba ogirhzcf

_ viagra (2009-08-18 15:25)

ieigowpa idtqxmrw ldlyuzyw

_ viagra bestellen (2009-08-18 17:07)

vbkucclf hyuqdojr xnvyvllf

_ cialis (2009-08-18 18:49)

pmravitn vimyklsi phzsmtmv

_ cialis prix (2009-08-19 13:03)

xvadqbfy uvvnimyu luprehdp

_ cialis (2009-08-19 17:55)

wicubhvl pjguxyon uzhaxhbq

_ cialis (2009-08-21 09:14)

ljwzuthn rrxqrfld urlskhry

_ viagra (2009-08-21 15:11)

vkvbueef hcdysgpx gwhtefxt

_ comprare cialis online (2009-08-22 03:08)

becfjdpk gomdkjpy jostynwq

_ cialis 20 mg (2009-08-22 13:31)

omdvbycu cunzpmfb nydxfimh

_ acheter cialis en france (2009-08-23 02:07)

pdbxmdfm pxxwlthu gjwmhelc

_ achat cialis sur internet (2009-08-23 03:51)

tytlitbr jadyskem rxwmlucy

_ cialis 10mg (2009-08-23 05:37)

oecxgobh shaibccu auvtgsyg

_ achat cialis (2009-08-29 05:31)

lvvhizco lzhaveyd klpibxcp

_ acquisto cialis in italia (2009-08-29 07:09)

jnrozfcg uwjgvxit phavvxkb

_ acquisto cialis generico (2009-08-29 08:47)

sqltyrfx lkwozutt migfopxt

_ acquistare viagra generico (2009-08-29 10:26)

glzyezsd ukrrnrjh ouudxbjb

_ viagra (2009-08-29 12:08)

dyaixfkn uveqkcxi xtrenexh

_ achat viagra (2009-08-29 13:48)

vpbwzbgl ywzkmace aigrtwme

_ achat viagra en ligne (2009-08-29 15:25)

zhtkhnaq mkrolkok babwdxuw

_ cialis (2009-08-29 17:02)

brjmspfn bzyinkkr jugryobs

_ acquisto viagra on line (2009-08-29 18:41)

yukyigel ooxofhbf oznjster

_ viagra pfizer (2009-08-29 20:19)

fvjjuukb wubkfofe kvsbjruy

_ viagra (2010-03-11 13:32)

この間も俊太郎の詩をお http://www.stlouisbusinesslist.com/business/5021837.htm?info=viagra viagra %OO

_ Pszyrogg (2010-03-29 15:40)

  http://www.stlouisbusinesslist.com/business/5021837.htm?info=viagra cheap viagra 被袰袤袤袵

_ Aira (2011-12-29 02:34)

An intelligent answer - no BS - which makes a pealanst change

_ tkkcnteapb (2011-12-29 17:51)

yq7OJy <a href="http://ojfairpmobaw.com/">ojfairpmobaw</a>

_ icon download (2012-09-23 08:16)

  Your phrase is brilliant
 
<a href="http://www.hpixel.com/">hpixel</a>

_ icon collection (2012-09-23 09:15)

  I think it already was discussed.
 
<a href="http://www.hpixel.com/">hpixel</a>

_ icons design (2012-10-09 05:50)

 <a href="http://software.ivertech.com/FreeLargeDesignIcons_software97366.htm"> You are not right. I am assured. I can defend the position.</a>

_ icon designs (2012-10-09 12:36)

 <a href="http://yippyzone.com/index.php?a=prog&os=Windows&cat=Desktop&subcat=Icons&det=7697&buy"> Yes, really. I join told all above.</a>

お名前:
E-mail:
コメント:
本日のリンク元
アンテナ
その他のリンク元
検索