On 26 April 2016 at 15:35, Charles Clavadetscher <clavadetsc...@swisspug.org > 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)
