PostgreSQL SQL - PostgesSQL equivalent of the Oracle 'contains' operator

Author

PostgesSQL equivalent of the Oracle 'contains' operator

Wm.A.Stafford

2006-11-10, 7:24 pm

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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly

Richard Broersma Jr

2006-11-10, 7:24 pm

> 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?

The other methods are to use regular expressions, but I do not expect them to be any faster than a
like. Have you looked at the contrib module tsearch2?
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/
Regards,

Richard Broersma Jr.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly

Sponsored Links