Revision 12638
Added by Aaron Marcuse-Kubitza almost 11 years ago
| validations.sql | ||
|---|---|---|
| 93 | 93 |
|
| 94 | 94 |
|
| 95 | 95 |
-- |
| 96 |
-- Name: _plots_07_list_of_plots_with_counts_of_individuals_per_species; Type: VIEW; Schema: SALVIAS; Owner: -
|
|
| 96 |
-- Name: _plots_07_list_of_plots_which_use_counts_of_indiv_per_species; Type: VIEW; Schema: SALVIAS; Owner: -
|
|
| 97 | 97 |
-- |
| 98 | 98 |
|
| 99 |
CREATE VIEW _plots_07_list_of_plots_with_counts_of_individuals_per_species AS
|
|
| 99 |
CREATE VIEW _plots_07_list_of_plots_which_use_counts_of_indiv_per_species AS
|
|
| 100 | 100 |
SELECT DISTINCT p.project_name, |
| 101 | 101 |
(pm."SiteCode")::text AS plot_code |
| 102 | 102 |
FROM ((projects p |
Also available in: Unified diff
bugfix: inputs/SALVIAS/validations.sql: plots_07_list_of_plots_with_counts_of_individuals_per_species: renamed to _plots_07_list_of_plots*which_use*_... because this query is not intended to include the actual counts, just to say which plots have them (the correct "which use" wording is also used in queries #8, 9)