Re: [ADMIN] Search string without tsearch

2008-01-29 Thread Markus Bertheau
2008/1/28, A.Burbello <[EMAIL PROTECTED]>: > 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

Re: [ADMIN] Search string without tsearch

2008-01-29 Thread Andrew Sullivan
On Mon, Jan 28, 2008 at 02:38:15PM -0300, A.Burbello wrote: > 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??? No. Also, rejecting the provided feature in the system for political reasons i

Re: [ADMIN] Search string without tsearch

2008-01-28 Thread Scott Marlowe
On Jan 28, 2008 11:38 AM, A.Burbello <[EMAIL PROTECTED]> 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

[ADMIN] Search string without tsearch

2008-01-28 Thread A.Burbello
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??? Thank you. Abra sua