On 26 April 2016 at 15:35, Charles Clavadetscher <clavadetscher@xxxxxxxxxxxx> wrote:
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.
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)
my lips will praise you. (Psalm 63:3)
