Search Postgresql Archives

Re: Full Text Index Scanning

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxx> wrote:
Matt Warner <matt@xxxxxxxxxxxxxxxxxxxx> 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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux