Project

General

Profile

« Previous | Next » 

Revision 10533

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

View differences:

inputs/HVAA/Specimen/postprocess.sql
1 1
SELECT util.search_path_append('util');
2 2

  
3
SELECT util.rename_cols(:table_str, $$
4
occurrenceRemarks => *occurrenceRemarks,
5
$$::hstore);
3 6

  
7

  
4 8
SELECT mk_derived_col((:table_str, 'occurrenceRemarks'),
5
$$_merge("*occurrenceRemarks_from_occurrenceRemarks", "occurrenceRemarks_from_dynamicProperties")$$)
9
$$_merge("*occurrenceRemarks", "dynamicProperties")$$)
6 10
; -- runtime: 1 s ("Time: 590.875 ms") @starscream

Also available in: Unified diff