Dear Ladies and Gentlemen,
i found a bug in the search in mediawiki for postgresql.
When using a wilcard in the search like "example*" the generated SQL statment is wrong. The genereated SQL statement is:
SELECT page_id, page_namespace, page_title, ts_rank('textvector', to_tsquery('example*'), 2) AS score FROM page p, revision r, pagecontent c WHERE p.page_latest = r.rev_id AND r.rev_text_id = c.old_id AND textvector @@ to_tsquery('example*');
But the part "to_tsquery('example*')" should be "to_tsquery('example:*')".
It think the best solution is to change the behavior of the function "parseQuery" in the file searchPostgres.php. There should be added that a trailing "*" become ":*".
If you need any other information let me know.
Yours,
Erich Lerch