Revision 11104
Added by Aaron Marcuse-Kubitza about 11 years ago
| inputs/VegBank/taxon_observation.**/postprocess.sql | ||
|---|---|---|
| 4 | 4 |
/* no row_num because left-join to stemcount_, stemlocation_ adds rows to each |
| 5 | 5 |
taxonobservation_ */ |
| 6 | 6 |
SELECT "identificationID" AS sort_col, * |
| 7 |
, _join("taxonOccurrenceID__overall_plot"::text, "aggregateOrganismObservationID") AS "taxonOccurrenceID"
|
|
| 7 |
, NULLIF(concat_ws('; ', "taxonOccurrenceID__overall_plot"::text, "aggregateOrganismObservationID"), '') AS "taxonOccurrenceID"
|
|
| 8 | 8 |
FROM taxonobservation_ |
| 9 | 9 |
NATURAL LEFT JOIN stemcount_ |
| 10 | 10 |
NATURAL LEFT JOIN stemlocation_ |
Also available in: Unified diff
bugfix: inputs/VegBank/taxon_observation.**/postprocess.sql: inlined _join() so that taxon_observation.** wouldn't get cascadingly deleted whenever the util schema (where this normally resides) gets reinstalled