PostgesSQL equivalent of the Oracle 'contains' operator

From: "Wm(dot)A(dot)Stafford" <stafford(at)marine(dot)rutgers(dot)edu>
To: pgsql-sql(at)postgresql(dot)org
Subject: PostgesSQL equivalent of the Oracle 'contains' operator
Date: 2006-11-10 16:10:22
Message-ID: 4554A46E.5020201@marine.rutgers.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Broersma Jr 2006-11-10 17:27:02 Re: PostgesSQL equivalent of the Oracle 'contains' operator
Previous Message Travis Whitton 2006-11-10 16:07:44 Re: Wildcard LIKE and Sub-select