summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--gentoobrowse/console/bugassociate.xml2
1 files changed, 1 insertions, 1 deletions
diff --git a/gentoobrowse/console/bugassociate.xml b/gentoobrowse/console/bugassociate.xml
index d18a98f..d8decc5 100644
--- a/gentoobrowse/console/bugassociate.xml
+++ b/gentoobrowse/console/bugassociate.xml
@@ -6,7 +6,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][^ ]*', '', 'g')) @@ PLAINTO_TSQUERY('english', c.name || '/' || p.name)
+ AND namedpackages(b.summary) @> ARRAY[c.name || '/' || p.name]
</sql>
<columns>
<column key="true">bugid</column>