Re: [PERFORM] regular expression search

2005-06-14 Thread Christopher Kings-Lynne
Just read the docs in contrib/tsearch2 in the PostgreSQL distribution. Pierre A. Fortier wrote: I search for particular strings using regular expressions (e.g. where column ~* $query) through a text data type column which contains notes (some html code like bold is included). It works but my qu

[PERFORM] regular expression search

2005-06-14 Thread Pierre A. Fortier
I search for particular strings using regular expressions (e.g. where column ~* $query) through a text data type column which contains notes (some html code like bold is included). It works but my question is whether there would be a way to speed up searches? >From my limited investigation, I see