pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgesSQL equivalent of the Oracle 'contains' operator
2+ messages / 2 participants
[nested] [flat]
* PostgesSQL equivalent of the Oracle 'contains' operator
@ 2006-11-10 16:10 Wm.A.Stafford <stafford@marine.rutgers.edu>
2006-11-10 17:27 ` Re: PostgesSQL equivalent of the Oracle 'contains' operator Richard Broersma Jr <rabroersma@yahoo.com>
0 siblings, 1 reply; 2+ messages in thread
From: Wm.A.Stafford @ 2006-11-10 16:10 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: PostgesSQL equivalent of the Oracle 'contains' operator
2006-11-10 16:10 PostgesSQL equivalent of the Oracle 'contains' operator Wm.A.Stafford <stafford@marine.rutgers.edu>
@ 2006-11-10 17:27 ` Richard Broersma Jr <rabroersma@yahoo.com>
0 siblings, 0 replies; 2+ messages in thread
From: Richard Broersma Jr @ 2006-11-10 17:27 UTC (permalink / raw)
To: stafford@marine.rutgers.edu; 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?
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.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2006-11-10 17:27 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-11-10 16:10 PostgesSQL equivalent of the Oracle 'contains' operator Wm.A.Stafford <stafford@marine.rutgers.edu>
2006-11-10 17:27 ` Richard Broersma Jr <rabroersma@yahoo.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox