Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 525D22E01D4 for ; Tue, 29 Jan 2008 13:43:54 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 75544-04 for ; Tue, 29 Jan 2008 13:43:39 -0400 (AST) Received: from main1.mycybernet.net (main1.mycybernet.net [209.222.63.135]) by postgresql.org (Postfix) with ESMTP id C73792E014A for ; Tue, 29 Jan 2008 13:43:40 -0400 (AST) Received: from 227-54-222-209.mycybernet.net ([209.222.54.227] helo=crankycanuck.ca) by main1.mycybernet.net with esmtp (Exim 4.62) (envelope-from ) id 1JJuUm-0004kS-8u for pgsql-admin@postgresql.org; Tue, 29 Jan 2008 12:43:40 -0500 Received: by crankycanuck.ca (Postfix, from userid 1000) id 5062250021; Tue, 29 Jan 2008 12:43:35 -0500 (EST) Date: Tue, 29 Jan 2008 12:43:35 -0500 From: Andrew Sullivan To: pgsql-admin@postgresql.org Subject: Re: Search string without tsearch Message-ID: <20080129174335.GC26594@crankycanuck.ca> Mail-Followup-To: Andrew Sullivan , pgsql-admin@postgresql.org References: <440310.20885.qm@web36204.mail.mud.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <440310.20885.qm@web36204.mail.mud.yahoo.com> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/275 X-Sequence-Number: 28049 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 is a poor technical choice. I sympathise, but whoever the politician is needs to get a clue, or you'll never be able to make the system operate as it should. A