On Thu, 28 Jun 2007, Andreas Joseph Krogh wrote:
Anybody knows if queries of type "LIKE '%234%'" ever will be able to use
indexes, and if someone is working on it? I'm sure I'm not the only one who
would very much appreciate it:-)
This is quite easily could be done with tsearch using substring dictionary.
Search archives !
Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
