root/trunk/inputs/Madidi/LocationObservation/postprocess.sql @ 13958
| 1 | 10346 | aaronmk | SELECT util.search_path_append('util'); |
|---|---|---|---|
| 2 | |||
| 3 | 13939 | aaronmk | SELECT mk_derived_col((:table_str, 'eventDate'), |
| 4 | $$"authorEventCode"$$); |
||
| 5 | |||
| 6 | 10346 | aaronmk | SELECT mk_derived_col((:table_str, 'locationRemarks'), |
| 7 | $$_alt("locationRemarks_1", "locationRemarks_2")$$); |
||
| 8 | -- _alt() is fine because only one of these is ever populated
|