Re: SELECT woes - Mailing list pgsql-novice

From Jeffrey Melloy
Subject Re: SELECT woes
Date
Msg-id D0ED8E11-DD53-11D7-B01B-000393C78AC0@visualdistortion.org
Whole thread Raw
In response to Re: SELECT woes  (Kevin Waterson <kevin@oceania.net>)
List pgsql-novice
On Tuesday, September 2, 2003, at 04:58  AM, Kevin Waterson wrote:

> 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.
>
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@postgresql.org so that your
>       message can get through to the mailing list cleanly


pgsql-novice by date:

Previous
From: "Mariano M. Gonzalez"
Date:
Subject: Using shared memory with postgresql
Next
From: Juan Francisco Diaz
Date:
Subject: Using COPY