From 4de86d2c97b9117db2808681d091f85c79279373 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 aee60a6f53..14a7e1427c 100644 --- a/Open-ILS/src/sql/Pg/012.schema.vandelay.sql +++ b/Open-ILS/src/sql/Pg/012.schema.vandelay.sql @@ -664,9 +664,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