From d1595452e147be462d7594cefd88ced46002c31c Mon Sep 17 00:00:00 2001
From: randomdan <randomdan@localhost>
Date: Tue, 14 Sep 2010 23:49:58 +0000
Subject: Fix regexp_replace to match multiple times

---
 gentoobrowse/console/bugassociate.xml | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/gentoobrowse/console/bugassociate.xml b/gentoobrowse/console/bugassociate.xml
index 655e33f..245c62d 100644
--- a/gentoobrowse/console/bugassociate.xml
+++ b/gentoobrowse/console/bugassociate.xml
@@ -7,7 +7,7 @@
 			SELECT b.bugid, p.packageid
 			FROM bugs b, packages p, categories c
 			WHERE p.categoryid = c.categoryid
-			AND TO_TSVECTOR('english', REGEXP_REPLACE(b.summary,'-[0-9][^ ]*','')) @@ PLAINTO_TSQUERY('english', c.name || '/' || p.name)
+			AND TO_TSVECTOR('english', REGEXP_REPLACE(b.summary, '-[0-9][^ ]*', '', 'g')) @@ PLAINTO_TSQUERY('english', c.name || '/' || p.name)
 		</sql>
 		<columns>
 			<column key="true">bugid</column>
-- 
cgit v1.2.3