Project

General

Profile

« Previous | Next » 

Revision 10532

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
SELECT util.search_path_append('util');
2

  
3

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

Also available in: Unified diff