From 84b73d6c3809df878d7990e30542c7ef83c0844f Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Wed, 13 May 2026 17:14:13 +0000 Subject: [PATCH] Use better SQL literal syntax --- conversion/load_aggressions.m4 | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/conversion/load_aggressions.m4 b/conversion/load_aggressions.m4 index dc34a30..b507245 100644 --- a/conversion/load_aggressions.m4 +++ b/conversion/load_aggressions.m4 @@ -136,9 +136,9 @@ BEGIN END , CASE -- badobs WHEN this_ae.ae_bad_observation_flag IS NULL THEN - '0' + FALSE WHEN this_ae.ae_bad_observeation_flag = 'X' THEN - '1' + TRUE ELSE 'Invalid' -- Blow up with an typecasting error END -- 2.34.1