The following commit has been merged in the master branch:
commit 9939d51b7951b79bae7e2a1e6b3c9ff37f148a6a
Author: Andreas Tille <[email protected]>
Date: Fri Feb 5 13:46:08 2016 +0100
Drop redundant field name information
diff --git a/misc/sql/edam.sh b/misc/sql/edam.sh
index ff5cbdb..16b0ba2 100755
--- a/misc/sql/edam.sh
+++ b/misc/sql/edam.sh
@@ -79,19 +79,19 @@ $JSONBEGIN
GROUP BY px.package, px.version
) pvar ON pvar.package = p.package AND pvar.version = p.version AND
pvar.release = p.release
LEFT OUTER JOIN (
- SELECT package, array_agg(tag) AS tags
+ SELECT package, array_agg(regexp_replace(tag, 'interface::', '')) AS
tags
FROM debtags
WHERE tag LIKE 'interface::%'
GROUP BY package
) interface ON interface.package = p.package
LEFT OUTER JOIN (
- SELECT package, array_agg(tag) AS tags
+ SELECT package, array_agg(regexp_replace(tag, 'biology::', '')) AS tags
FROM debtags
WHERE tag LIKE 'biology::%'
GROUP BY package
) biology ON biology.package = p.package
LEFT OUTER JOIN (
- SELECT package, array_agg(tag) AS tags
+ SELECT package, array_agg(regexp_replace(tag, 'field::', '')) AS tags
FROM debtags
WHERE tag LIKE 'field::%'
GROUP BY package
--
Static and dynamic websites for Debian Pure Blends
_______________________________________________
Blends-commit mailing list
[email protected]
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/blends-commit
