Project

General

Profile

« Previous | Next » 

Revision 10592

inputs/U/Specimen/map.csv: translated remaining multi-column filters to postprocessing derived columns, using the steps at http://wiki.vegpath.org/Adding_new-style_import_to_a_datasource#Translating-filters-to-postprocessing-derived-columns

View differences:

postprocess.sql
4 4
SELECT mk_derived_col((:table_str, 'county'),
5 5
$$_alt("Gazetteer", "Newgazett")$$)
6 6
; -- runtime: 0.5 s ("Time: 610.516 ms") @starscream
7

  
8
SELECT mk_derived_col((:table_str, 'recordedBy'),
9
$$_join("Collector", "Addcoll")$$)
10
; -- runtime: 2 s ("Time: 2273.582 ms") @starscream

Also available in: Unified diff