PostgesSQL equivalent of the Oracle 'contains' operator

Поиск
Список
Период
Сортировка
От Wm.A.Stafford
Тема PostgesSQL equivalent of the Oracle 'contains' operator
Дата
Msg-id 4554A46E.5020201@marine.rutgers.edu
обсуждение исходный текст
Ответы Re: PostgesSQL equivalent of the Oracle 'contains' operator
Список 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 по дате отправления:

Предыдущее
От: "Travis Whitton"
Дата:
Сообщение: Re: Wildcard LIKE and Sub-select
Следующее
От: Richard Broersma Jr
Дата:
Сообщение: Re: PostgesSQL equivalent of the Oracle 'contains' operator