Re: Full Text Index Scanning

Aha! Thanks for pointing that out. It's indexing now.

Thanks!

Matt

On Sun, Jan 30, 2011 at 9:12 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> 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
>