Re: Search string without tsearch

["Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>]

On Jan 28, 2008 11:38 AM, A.Burbello <burbello3000(at)yahoo(dot)com(dot)br> wrote:
> Hi people,
>
> I would like to some suggestion to search person name
> in a table that has more than 150 milions of rows ...
>
> e.g ... name like 'JOHN%SMITH';
>
> I know there is contrib Tsearch, but I can't for
> political reasons.
> Is there any way to do with good performance???

Would pointing out to the PHBs that tsearch was integrated into pgsql
with v8.3 help convince them to stop being reactionary idiots?