Re: Strange behavior on to_tsquery()

Rodrigo Hjort <rodrigo.hjort@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