From aa9885b86f5d6c01642976a7700eb00abb595426 Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Thu, 18 Jan 2024 21:45:12 +0000 Subject: [PATCH] These cleanups were done in the upstream data --- conversion/clean.sql | 23 ----------------------- 1 file changed, 23 deletions(-) diff --git a/conversion/clean.sql b/conversion/clean.sql index 3c40b2d..7a23fd9 100644 --- a/conversion/clean.sql +++ b/conversion/clean.sql @@ -17,26 +17,3 @@ -- -- Karl O. Pinc --- BIOGRAPHY - --- (#6) BIOGRAPHY.B_AnimID_num column contains the empty string --- Change '' to NULL -UPDATE biography - SET b_animid_num = NULL - WHERE b_animid_num = ''; - --- (#7) BIOGRAPHY.B_AnimID_num column is textual --- Get rid of leading "CH" -UPDATE biography - SET b_animid_num = SUBSTRING(b_animid_num FROM 3) - WHERE UPPER(SUBSTRING(b_animid_num FOR 2)) = 'CH'; --- Change data type to INT -ALTER TABLE biography - ALTER b_animid_num TYPE INT - USING b_animid_num::INTEGER; - --- (#8) BIOGRAPHY.DadID_publication_info column contains NULL values --- Change NULL to '' -UPDATE biography - SET b_dadid_publication_info = '' - WHERE b_dadid_publication_info IS NULL; -- 2.34.1