| From: | Johann Spies <johann(dot)spies(at)gmail(dot)com> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: 9.5: tsvector problem |
| Date: | 2016-04-26 13:46:16 |
| Message-ID: | CAGZ55DS3X-o_ese1e5+TVxVyDzYwiO9BmJvhpcppCheOLi118g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 26 April 2016 at 15:35, Charles Clavadetscher <clavadetscher(at)swisspug(dot)org
> wrote:
> Hello Johann
>
> There are two to_tsvector functions:
>
> charles(at)charles(dot)[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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | david | 2016-04-26 13:48:12 | Re: Problems running the WorkerSpi sample |
| Previous Message | Ihnat Peter | TSS Group a.s. | 2016-04-26 13:39:55 | Re: Background worker with Listen |