diff options
| author | randomdan <randomdan@localhost> | 2010-09-14 23:49:58 +0000 |
|---|---|---|
| committer | randomdan <randomdan@localhost> | 2010-09-14 23:49:58 +0000 |
| commit | d1595452e147be462d7594cefd88ced46002c31c (patch) | |
| tree | 2d73019ef33a35ee949e95e19ef93f7fa40cddaf | |
| parent | Fix Chromium irritation with whitespace in tooltips (diff) | |
| download | gentoobrowse-d1595452e147be462d7594cefd88ced46002c31c.tar.bz2 gentoobrowse-d1595452e147be462d7594cefd88ced46002c31c.tar.xz gentoobrowse-d1595452e147be462d7594cefd88ced46002c31c.zip | |
Fix regexp_replace to match multiple times
| -rw-r--r-- | gentoobrowse/console/bugassociate.xml | 2 |
1 files changed, 1 insertions, 1 deletions
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> |