PostgesSQL equivalent of the Oracle 'contains' operator - Mailing list pgsql-sql

From Wm.A.Stafford
Subject PostgesSQL equivalent of the Oracle 'contains' operator
Date
Msg-id 4554A46E.5020201@marine.rutgers.edu
Whole thread Raw
Responses Re: PostgesSQL equivalent of the Oracle 'contains' operator
List pgsql-sql
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


pgsql-sql by date:

Previous
From: "Travis Whitton"
Date:
Subject: Re: Wildcard LIKE and Sub-select
Next
From: Richard Broersma Jr
Date:
Subject: Re: PostgesSQL equivalent of the Oracle 'contains' operator