Oleg Bartunov <oleg@xxxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
