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.
Thanks Charles. That solved it. Strange that this was not necessary in 9.4 though.
Regards.
Johann
--
Because experiencing your loyal love is better than life itself, my lips will praise you. (Psalm 63:3)