Re: 9.5: tsvector problem - Mailing list pgsql-general

From Johann Spies
Subject Re: 9.5: tsvector problem
Date
Msg-id CAGZ55DS3X-o_ese1e5+TVxVyDzYwiO9BmJvhpcppCheOLi118g@mail.gmail.com
Whole thread Raw
In response to Re: 9.5: tsvector problem  (Charles Clavadetscher <clavadetscher@swisspug.org>)
List pgsql-general

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

pgsql-general by date:

Previous
From: Charles Clavadetscher
Date:
Subject: Re: 9.5: tsvector problem
Next
From:
Date:
Subject: Re: Problems running the WorkerSpi sample