Re: SELECT woes

This one time, at band camp, Jeffrey Melloy  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