From 01b5159b9cd62bb64c5ddf5ec5c22b47cd4be60d Mon Sep 17 00:00:00 2001 From: Dan Goodliffe Date: Sun, 23 Aug 2015 03:49:29 +0100 Subject: Filter out wildly inaccurate changelog dates, but accept long month names --- gentoobrowse/console/changelogs.xml | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/gentoobrowse/console/changelogs.xml b/gentoobrowse/console/changelogs.xml index 0e191bf..16fe5bf 100644 --- a/gentoobrowse/console/changelogs.xml +++ b/gentoobrowse/console/changelogs.xml @@ -20,7 +20,7 @@ TRIM(l[4]) AS comment FROM ( SELECT repoid, cat, pkg, n, - REGEXP_MATCHES(r, '(\d+ *(?:jan|feb|mar|apr|may|jun|jul|aug|sep|oct|nov|dec) \d+); (.+)? <(.+@[^ >]+)[>\s] (?:[^:]*:)? (.*)', 'i') l + REGEXP_MATCHES(r, '(\d{1,2} *(?:jan|feb|mar|apr|may|jun|jul|aug|sep|oct|nov|dec)\w* 2\d{3}); (.+)? <(.+@[^ >]+)[>\s] (?:[^:]*:)? (.*)', 'i') l FROM ( SELECT repoid, pathparts[1] cat, pathparts[2] pkg, REGEXP_REPLACE(r, '\s+', ' ', 'g') r, ROW_NUMBER() OVER() n FROM files f, REGEXP_SPLIT_TO_TABLE(PG_READ_FILE(filename), '\n\s*\n') r -- cgit v1.2.3