From 7aada943fc135b4e24dde6d82d0612b03e123940 Mon Sep 17 00:00:00 2001 From: randomdan Date: Tue, 19 Jul 2011 18:12:43 +0000 Subject: Fix the cases when masks contain a full month name --- gentoobrowse/console/packagemasks.xml | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/gentoobrowse/console/packagemasks.xml b/gentoobrowse/console/packagemasks.xml index 36d00b3..915e115 100644 --- a/gentoobrowse/console/packagemasks.xml +++ b/gentoobrowse/console/packagemasks.xml @@ -6,7 +6,7 @@ SELECT d.setno, MIN(field[1]) AS person, MIN(field[2]) AS email, - CAST((REGEXP_MATCHES(MIN(field[3]), E'(\\d+ *(jan|feb|mar|apr|may|jun|jul|aug|sep|oct|nov|dec) \\d+)', 'i'))[1] AS DATE) AS dateadded, + CAST((REGEXP_MATCHES(MIN(field[3]), E'(\\d+ *(jan|feb|mar|apr|may|jun|jul|aug|sep|oct|nov|dec)\\w* \\d+)', 'i'))[1] AS DATE) AS dateadded, TRIM(STRING_AGG(REGEXP_REPLACE(content, '^#+', ''), ' ' ORDER BY m.line)) AS message FROM (SELECT setno, line AS line, REGEXP_MATCHES(content, E'^# *(.+) +< *(.+) *> \\( *(.+) *\\)$') AS field FROM file_masks_withset -- cgit v1.2.3