diff options
| author | randomdan <randomdan@localhost> | 2012-08-08 20:19:00 +0000 |
|---|---|---|
| committer | randomdan <randomdan@localhost> | 2012-08-08 20:19:00 +0000 |
| commit | 4a66b05d92ace1e6fea4a7def3810a6310a277f4 (patch) | |
| tree | 11e750e9e95cf7dc9b315e600e493ab96ce85481 | |
| parent | Tweak to work with + prefix on use flags (diff) | |
| download | gentoobrowse-4a66b05d92ace1e6fea4a7def3810a6310a277f4.tar.bz2 gentoobrowse-4a66b05d92ace1e6fea4a7def3810a6310a277f4.tar.xz gentoobrowse-4a66b05d92ace1e6fea4a7def3810a6310a277f4.zip | |
Correct split homepages for package URLs
| -rw-r--r-- | gentoobrowse/console/packageimport.xml | 2 |
1 files changed, 1 insertions, 1 deletions
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 |