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
___________________________________