Re: SELECT woes

This one time, at band camp, Jeffrey Melloy <jmelloy(at)visualdistortion(dot)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