From 27948d2b3b29fb21518c324b8866c2e57816bb00 Mon Sep 17 00:00:00 2001
From: senator <lebbeous@esilibrary.com>
Date: Fri, 22 Apr 2011 12:12:30 -0400
Subject: [PATCH] Bugfix for negative matches

---
 Open-ILS/src/sql/Pg/012.schema.vandelay.sql | 4 +---
 1 file changed, 1 insertion(+), 3 deletions(-)

diff --git a/Open-ILS/src/sql/Pg/012.schema.vandelay.sql b/Open-ILS/src/sql/Pg/012.schema.vandelay.sql
index 687f1618d4..eeb8e2a610 100644
--- a/Open-ILS/src/sql/Pg/012.schema.vandelay.sql
+++ b/Open-ILS/src/sql/Pg/012.schema.vandelay.sql
@@ -681,9 +681,7 @@ BEGIN
     IF node.bool_op IS NOT NULL THEN
         RETURN node.bool_op;
     ELSE
-        RETURN '(n' || node.id::TEXT || '.id IS ' ||
-            (CASE WHEN node.negate THEN '' ELSE 'NOT ' END) ||  -- sic!
-            'NULL)';
+        RETURN '(n' || node.id::TEXT || '.id IS NOT NULL)';
     END IF;
 END;
 $$ LANGUAGE PLPGSQL;
-- 
2.11.0