From 4a66b05d92ace1e6fea4a7def3810a6310a277f4 Mon Sep 17 00:00:00 2001
From: randomdan <randomdan@localhost>
Date: Wed, 8 Aug 2012 20:19:00 +0000
Subject: Correct split homepages for package URLs

---
 gentoobrowse/console/packageimport.xml | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/gentoobrowse/console/packageimport.xml b/gentoobrowse/console/packageimport.xml
index 4844dd0..a16a037 100644
--- a/gentoobrowse/console/packageimport.xml
+++ b/gentoobrowse/console/packageimport.xml
@@ -91,7 +91,7 @@
 
 	<project2:sqlmerge name="urls" datasource="postgres" targettable="package_urls" useview="yes">
 		<sql>
-			SELECT DISTINCT p.packageid, e.homepage AS url
+			SELECT DISTINCT p.packageid, REGEXP_SPLIT_TO_TABLE(e.homepage, ' ') AS url
 			FROM ebuilddefs e, packages p
 			WHERE e.pkgname = p.name
 			AND e.categoryid = p.categoryid
-- 
cgit v1.2.3