From 53d5fc4854fff3fe4eab421add896192e80bec42 Mon Sep 17 00:00:00 2001 From: Jesse Luehrs Date: Sat, 14 Nov 2020 16:34:38 -0500 Subject: fix null handling --- data/denorm.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'data') diff --git a/data/denorm.sql b/data/denorm.sql index 51080bf..cca7884 100644 --- a/data/denorm.sql +++ b/data/denorm.sql @@ -349,5 +349,5 @@ CREATE VIEW spending AS ( category != 'Donations' and category != 'Family' and category != 'Reimbursables' and - memo != 'down payment' + (memo IS NULL or memo != 'down payment') ); -- cgit v1.2.3-54-g00ecf