Re: 9.5: tsvector problem

Hello Johann

There are two to_tsvector functions:

charles@charles.[local]=# \df to_tsvector
                             List of functions
   Schema   |    Name     | Result data type | Argument data types | Type
------------+-------------+------------------+---------------------+--------
 pg_catalog | to_tsvector | tsvector         | regconfig, text     | normal
 pg_catalog | to_tsvector | tsvector         | text                | normal
(2 rows)

I think that you may try casting the result of coalesce() to TEXT.