Re: tsearch2 and case

Oleg Bartunov <oleg@sai.msu.su> writes:

> > I'd like the search to be completely case insensitive. Can anyone point me in
> > the right direction?
>
> use your own dictionary ! Read gendict tutorial for details.
> http://www.sai.msu.su/~megera/oddmuse/index.cgi/Gendict
> I would create simple dictionary abbrev which recognize your abbreviations
> and use it first before any other dicts. btw, if you did it general enough
> please share with us, so other people could use it.

Do functional indexes interact well with tsearch? Couldn't you just make your
index on lower(col) and then do to_tsquery(lower('ABCD')) ?


--
greg