Re: [SQL] PostgesSQL equivalent of the Oracle 'contains' operator

2006-11-10 Thread Richard Broersma Jr
> 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'

[SQL] PostgesSQL equivalent of the Oracle 'contains' operator

2006-11-10 Thread Wm.A.Stafford
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