<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>
