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 <m...@warnertechnology.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 <t...@sss.pgh.pa.us> wrote: > >> Matt Warner <m...@warnertechnology.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 >> > >
