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
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