Re: Full Text Index Scanning

If I understand this, it looks like this approach allows me to match the
beginnings and endings of words, but not the middle sections. Is that
correct? That is, if I search for "jag" I will find "jaeger" but not
"lobenjager".

Or am I (again) not understanding how this works?

TIA,

Matt

On Sun, Jan 30, 2011 at 9:59 AM, Matt Warner <matt(at)warnertechnology(dot)com>wrote:

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