Received: from sss.sss.pgh.pa.us (sss.pgh.pa.us [206.210.65.6]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA00848 for ; Wed, 9 Jun 1999 10:44:50 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.sss.pgh.pa.us (8.9.1/8.9.1) with ESMTP id KAA28836; Wed, 9 Jun 1999 10:43:36 -0400 (EDT) To: Michal Samek cc: pgsql-sql Subject: Re: [SQL] Select like when searching for whole word and optimizing it In-reply-to: Your message of Wed, 09 Jun 1999 10:41:02 +0200 <375E289E.EF906BD2@tony.cz> Date: Wed, 09 Jun 1999 10:43:36 -0400 Message-ID: <28834.928939416@sss.pgh.pa.us> From: Tom Lane Michal Samek writes: > Maybe there is some better way to search for the whole word? I think you want to build a secondary table and search that. Take a look at the stuff in contrib/fulltextindex; it may solve your problem as-is, and if not you can probably adapt it to your needs... regards, tom lane