Re: Full Text Index Scanning

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Matt Warner <matt(at)warnertechnology(dot)com>
Cc: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>, pgsql-general(at)postgresql(dot)org
Subject: Re: Full Text Index Scanning
Date: 2011-01-30 17:12:40
Message-ID: 1674.1296407560@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Matt Warner <matt(at)warnertechnology(dot)com> writes:
> Doesn't seem to work either. Maybe something changed in 9.1?
> create index test_idx on testtable using gin(to_tsvector(wordcolumn||'
> '||reverse(wordcolumn)));
> ERROR: functions in index expression must be marked IMMUTABLE

That's not the same case he tested. The single-parameter form of
to_tsvector isn't immutable, because it depends on the default text
search configuration parameter. It should work, AFAICS, with the
two-parameter form.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Matt Warner 2011-01-30 17:59:16 Re: Full Text Index Scanning
Previous Message Matt Warner 2011-01-30 16:35:47 Re: Full Text Index Scanning