root/inputs/NCU/Specimen/postprocess.sql @ 11927
| 1 | 10568 | aaronmk | SELECT util.search_path_append('util'); |
|---|---|---|---|
| 2 | |||
| 3 | |||
| 4 | -- cultivated can only be true or NULL, not false
|
||
| 5 | SELECT mk_derived_col((:table_str, 'cultivated'), |
||
| 6 | 10569 | aaronmk | $$_map('0=>NULL, -1=>true, *=>*', "cultivated_verbatim")$$) |
| 7 | 10568 | aaronmk | ; -- runtime: 4 s ("Time: 3768.112 ms") @starscream |