Index: openacs-4/packages/forums/www/search-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/www/Attic/search-postgresql.xql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/forums/www/search-postgresql.xql	20 Jun 2003 15:24:24 -0000	1.4
+++ openacs-4/packages/forums/www/search-postgresql.xql	3 Oct 2003 10:33:26 -0000	1.5
@@ -14,10 +14,8 @@
             where forums_messages.forum_id = forums_forums.forum_id
             and forums_forums.package_id = :package_id
             and forums_messages.state = 'approved'
-            and (    forums_messages.subject like ('%' || :search_text || '%')
-                  or forums_messages.content like ('%' || :search_text || '%')
-                  or person__name(forums_messages.user_id) like ('%' || :search_text || '%')
-                )
+            and upper(forums_messages.subject || ' ' || forums_messages.content || ' ' || person__name(forums_messages.user_id))
+                like '%' || upper(:search_text) || '%'
             order by the_score desc,
                      forums_messages.posting_date desc
         </querytext>
@@ -35,10 +33,8 @@
             and forums_forums.package_id = :package_id
             and forums_messages.forum_id = forums_forums.forum_id
             and forums_messages.state = 'approved'
-            and (    forums_messages.subject like ('%' || :search_text || '%')
-                  or forums_messages.content like ('%' || :search_text || '%')
-                  or person__name(forums_messages.user_id) like ('%' || :search_text || '%')
-                )
+            and upper(forums_messages.subject || ' ' || forums_messages.content || ' ' || person__name(forums_messages.user_id))
+                like '%' || upper(:search_text) || '%'
             order by the_score desc,
                      forums_messages.posting_date desc
         </querytext>