Re: SELECT woes

On Tuesday, September 2, 2003, at 04:58 AM, Kevin Waterson wrote:

> 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.
>
You didn't list that as a constraint. :)
> Kind regards
> Kevin
>
>
> --
> ______
> (_____ \
> _____) ) ____ ____ ____ ____
> | ____/ / _ ) / _ | / ___) / _ )
> | | ( (/ / ( ( | |( (___ ( (/ /
> |_| \____) \_||_| \____) \____)
> Kevin Waterson
> Port Macquarie, Australia
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly