From c495a745d0318a3a009ac5a7f07951217190c37d Mon Sep 17 00:00:00 2001
From: Dan Goodliffe <dan@randomdan.homeip.net>
Date: Fri, 21 Aug 2015 15:48:12 +0100
Subject: Fix herd in category view now DB correctly contains nulls, not empty
 strings

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

diff --git a/gentoobrowse/views/category.xml b/gentoobrowse/views/category.xml
index 01baa14..c14c2d2 100644
--- a/gentoobrowse/views/category.xml
+++ b/gentoobrowse/views/category.xml
@@ -3,7 +3,7 @@
 		xmlns:project2="http://project2.randomdan.homeip.net">
 	<project2:sqlrows name="categoryPackages" datasource="postgres-web">
 		<sql>
-			SELECT c.name AS catname, p.name AS pkgname, p.description, CASE WHEN p.herd = '' THEN '-none-' ELSE p.herd END as herd
+			SELECT c.name AS catname, p.name AS pkgname, p.description, COALESCE(herd, '-none-') herd
 			FROM categories c, packages p
 			WHERE c.categoryid = p.categoryid
 			<filter name="byCatName">AND c.name = <param name="catname" /></filter>
-- 
cgit v1.2.3