Thread: Select Match on PostgreSQL.
<br /> Hi,<br /><br /> I'm looking for a SELECT request on PostgreSQL for a search engine.<br /> I'd like the request
returnme the pertinence (relevance) of each result.<br /><br /> I've found the MySQL syntax on the web :<br />
mysql>SELECT id, body, MATCH (title,body) AGAINST<br /> -> ('Security implications of running MySQL as root') AS
score<br/> -> FROM articles WHERE MATCH (title,body) AGAINST<br /> -> ('Security implications of running MySQL as
root');<br/><br /> But how can I do it on PostgreSQL where Match syntax is not accepted ?<br /><br /> Thanks to help
me.<br/><br /> Regards.<br /><p> Laurent Patureau.<br /> Co-gérant / Ingénieur d'Affaire.<br />
____________________________________<br/><font size="2"> Laurent Patureau<br />
</font><font size="1">S.A.R.L.</font><font size="2"> ID.fr<br /><br /> <a
eudora="autourl"href="mailto:lpatureau@idfr.net">mailto:lpatureau@idfr.net</a><br /><br /> <a
eudora="autourl"href="http://www.idfr.net/">http://www.idfr.net</a><br /><br /> Porter un nouveau regard à votre
audience:<br /> <a eudora="autourl" href="http://www.wysistat.com/">http://www.wysistat.com</a><br
/><br/> Tel : 03 81 48 03 13<br /> Fax : 03 81 48 04 83<br /><br />
16, Boulevard Winston Churchill<br /> 25 000 Besançon<br />
___________________________________</font>
Laurent, take a look at contrib/tsearch2 http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/ It does exactly what you want and more. Oleg On Fri, 29 Aug 2003, Laurent Patureau wrote: > > Hi, > > I'm looking for a SELECT request on PostgreSQL for a search engine. > I'd like the request return me the pertinence (relevance) of each result. > > I've found the MySQL syntax on the web : > mysql> SELECT id, body, MATCH (title,body) AGAINST > -> ('Security implications of running MySQL as root') AS score > -> FROM articles WHERE MATCH (title,body) AGAINST > -> ('Security implications of running MySQL as root'); > > But how can I do it on PostgreSQL where Match syntax is not accepted ? > > Thanks to help me. > > Regards. > > Laurent Patureau. > Co-gИrant / IngИnieur d'Affaire. > ____________________________________ > Laurent Patureau > S.A.R.L. ID.fr > > mailto:lpatureau@idfr.net > > http://www.idfr.net > > Porter un nouveau regard Ю votre audience : > http://www.wysistat.com > > Tel : 03 81 48 03 13 > Fax : 03 81 48 04 83 > > 16, Boulevard Winston Churchill > 25 000 BesanГon > ___________________________________ > Regards, Oleg _____________________________________________________________ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83