Received: from localhost (wm.hub.org [200.46.204.128])
	by postgresql.org (Postfix) with ESMTP id ED0579FA3A7
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 10 Nov 2006 12:34:47 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024)
	with ESMTP id 85302-06 for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 10 Nov 2006 16:34:33 +0000 (UTC)
X-Greylist: delayed 00:24:03.163042 by SQLgrey-
Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159])
	by postgresql.org (Postfix) with ESMTP id BD4249FB333
	for <pgsql-sql@postgresql.org>; Fri, 10 Nov 2006 12:34:32 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3
Received: from bottle.marine.rutgers.edu (bottle.marine.rutgers.edu
	[165.230.166.145])
	by svr4.postgresql.org (Postfix) with ESMTP id 52E565AF8A8
	for <pgsql-sql@postgresql.org>; Fri, 10 Nov 2006 16:10:28 +0000 (GMT)
Received: from [192.168.50.5] (shah-lt.marine.rutgers.edu [192.168.50.5])
	(authenticated bits=0)
	by bottle.marine.rutgers.edu (8.12.11.20060308/8.12.11) with ESMTP id
	kAAGAPDN029656
	(version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO)
	for <pgsql-sql@postgresql.org>; Fri, 10 Nov 2006 11:10:25 -0500
Message-ID: <4554A46E.5020201@marine.rutgers.edu>
Date: Fri, 10 Nov 2006 11:10:22 -0500
From: "Wm.A.Stafford" <stafford@marine.rutgers.edu>
Reply-To: stafford@marine.rutgers.edu
Organization: Institute  of Marine and Coastal Sciences
User-Agent: Thunderbird 1.5.0.8 (Windows/20061025)
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: PostgesSQL equivalent of the Oracle 'contains'  operator
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Scanned-By: MIMEDefang 2.41
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200611/115
X-Sequence-Number: 26767

I'm beginning  a port of an Oracle  application to PostgrSQL.  One 
immediate issue is the use of the  Oracle 'contains' operator to do 
whole word searches on table rows that contain blank separated lists of 
names.  I  was told that the original application was written using the 
'like' operator but the contains operator was found to be much faster.

Is there a PostgreSQL equivalent for this type of use of the Oracle 
contains?

Thanks,
-=bill  stafford