Rodrigo Hjort <rodrigo.hj...@gmail.com> writes: > I created a *custom dictionary* (based on dict_int) and a search > configuration and a strange behavior happens on *PostgreSQL 8.4.9*. > ... > Therefore, when I use *@@ operator* over a *tsvector* column in my table > the result set is not always the same.
This almost certainly means a bug in your dictionary code. > 2) Sometimes the value returned by *to_tsquery()* has a ":*" suffix. What > does that mean? Prefix search request. Possibly you're forgetting to zero out the prefix flag? (Just offhand, it rather looks like dict_int and dict_xsyn are both assuming that palloc will give back zeroed space, which is bogus...) regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers