Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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


pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group