Revision 14521
Added by Aaron Marcuse-Kubitza over 10 years ago
| public_.sql | ||
|---|---|---|
| 10644 | 10644 |
-- |
| 10645 | 10645 |
|
| 10646 | 10646 |
CREATE VIEW native_status_resolver AS |
| 10647 |
SELECT DISTINCT view_full_occurrence_individual.taxonobservation_id AS id, |
|
| 10648 |
view_full_occurrence_individual.scrubbed_family AS family, |
|
| 10647 |
SELECT DISTINCT view_full_occurrence_individual.scrubbed_family AS family, |
|
| 10649 | 10648 |
view_full_occurrence_individual.scrubbed_genus AS genus, |
| 10650 | 10649 |
view_full_occurrence_individual.scrubbed_species_binomial AS species_binomial, |
| 10651 | 10650 |
view_full_occurrence_individual.country, |
Also available in: Unified diff
fix: schemas/public_.sql: native_status_resolver: remove the id because this prevents SELECT DISTINCT from having the desired effect. instead, the results will be joined back using the other columns.