Project

General

Profile

« Previous | Next » 

Revision 11269

fix: inputs/CVS/taxonObservation_/postprocess.sql: removed {} around denorm_genus to match the normalized genus

View differences:

postprocess.sql
4 4
denorm_kingdom = "Kingdom"
5 5
WHERE denorm_kingdom != "Kingdom"/*implies both NOT NULL*/ -- applies to 1 row (PLANTCONCEPT_ID 92372)
6 6
; -- rerun time: 0.5 s ("710.176 ms") @starscream; runtime: 2 s ("2211.789 ms") @starscream
7

  
8
UPDATE :table SET
9
denorm_genus = trim(denorm_genus, '{}') -- applies to 6 rows
10
WHERE denorm_genus LIKE '{%}' -- applies to 6 rows
11
; -- rerun time: 0.5 s ("492.670 ms") @starscream; runtime: 0.5 s ("543.942 ms") @starscream

Also available in: Unified diff