From 9f4e930e91071f44494e893a7095b642a7d4cf5f Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Sat, 11 Oct 2025 23:47:06 +0000 Subject: [PATCH] Cleanup of problem #31 and #32 taken care of in clean schema --- conversion/load_follow_to_follows.sql | 4 +--- 1 file changed, 1 insertion(+), 3 deletions(-) diff --git a/conversion/load_follow_to_follows.sql b/conversion/load_follow_to_follows.sql index 996b2f0..8bce4f7 100644 --- a/conversion/load_follow_to_follows.sql +++ b/conversion/load_follow_to_follows.sql @@ -109,9 +109,7 @@ INSERT INTO follow_observers ( , obs_brec , obs_tiki) WITH obs AS ( -SELECT upper( -- problem #31 - btrim( -- problem #32 - follow.fol_b_animid)) AS fol_b_animid +SELECT follow.fol_b_animid , follow.fol_date , follow.fol_am_observer_1 AS am_obs1 , follow.fol_am_observer_2 AS am_obs2 -- 2.34.1