Select Match on PostgreSQL.
От | Laurent Patureau |
---|---|
Тема | Select Match on PostgreSQL. |
Дата | |
Msg-id | 5.0.0.25.0.20030829123618.02819278@pop.noos.fr обсуждение исходный текст |
Ответы |
Re: Select Match on PostgreSQL.
|
Список | pgsql-sql |
<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>
В списке pgsql-sql по дате отправления: