From: edd <edd@edb9625f-4e0d-4859-8d74-9fd3b1da38cb>
Date: Sat, 23 Jan 2010 16:54:00 +0000 (+0000)
Subject: added simply 'group by' on explanation for db_blacklist_reason
X-Git-Url: https://git.donarmstrong.com/?p=cran2deb.git;a=commitdiff_plain;h=4d4cddf653d343a22e31624f09d1bf814e7a6f68

added simply 'group by' on explanation for db_blacklist_reason


git-svn-id: svn://svn.r-forge.r-project.org/svnroot/cran2deb@296 edb9625f-4e0d-4859-8d74-9fd3b1da38cb
---

diff --git a/trunk/R/db.R b/trunk/R/db.R
index 163ba9a..e563c71 100644
--- a/trunk/R/db.R
+++ b/trunk/R/db.R
@@ -442,7 +442,7 @@ db_blacklist_packages <- function() {
 
 db_blacklist_reasons <- function () {
     con <- db_start()
-    packages <- dbGetQuery(con,'SELECT package,explanation from blacklist_packages')
+    packages <- dbGetQuery(con,'SELECT package,explanation from blacklist_packages group by explanation')
     db_stop(con)
     return(packages)
 }