Re: SELECT woes

This one time, at band camp, Jeffrey Melloy <jmelloy@visualdistortion.org> wrote:

> Yuck.
>
> My suggestion would be to install the tsearch or tsearch2 module, and
> modify the on-insert trigger to include the contents of all the fields
> in your table.  There are examples in the tsearch readme, but you can
> set the trigger on multiple columns.  Then that query would probably be
> very fast and would turn into
> select * from table where master_idx ## 'my|name|is|bill'
> You can also do more powerful levels of grouping and boolean logic.
> Jeff
> On Tuesday, September 2, 2003, at 02:51  AM, Kevin Waterson wrote:

Then it would not be compatible with other databases.

Kind regards
Kevin


--
 ______
(_____ \
 _____) )  ____   ____   ____   ____
|  ____/  / _  ) / _  | / ___) / _  )
| |      ( (/ / ( ( | |( (___ ( (/ /
|_|       \____) \_||_| \____) \____)
Kevin Waterson
Port Macquarie, Australia