Hello PG hackers, I created a *custom dictionary* (based on dict_int) and a search configuration and a strange behavior happens on *PostgreSQL 8.4.9*.
When I invoke the following instruction several times,* to_tsquery()*returns distinct results: catalog=> SELECT to_tsquery('custom', 'pi'); to_tsquery ------------ 'pi':* (1 registro) catalog=> SELECT to_tsquery('custom', 'pi'); to_tsquery ------------ 'pi' (1 registro) Therefore, when I use *@@ operator* over a *tsvector* column in my table the result set is not always the same. 1) Do you have any clue on what could be happening and how to solve this issue, please? 2) Sometimes the value returned by *to_tsquery()* has a ":*" suffix. What does that mean? Thanks in advance. Best Regards, -- Rodrigo Hjort www.hjort.co