Project

General

Profile

« Previous | Next » 

Revision 10535

inputs/HVAA/: switched to new-style import, using the steps at wiki.vegpath.org/Adding_new-style_import_to_a_datasource

View differences:

postprocess.sql
1 1
SELECT util.search_path_append('util');
2 2

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

  
7

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

Also available in: Unified diff