Revision 13395
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/validation/aggregating/plots/bien3_validations_salvias_vegbien.sql | ||
|---|---|---|
| 343 | 343 |
WHERE ((taxonlabel.source_id = ( SELECT source_by_shortname(:datasource::text) AS source_by_shortname)) AND (taxonlabel.taxonomicname IS NOT NULL)); |
| 344 | 344 |
|
| 345 | 345 |
-- _plots_21_tnrs_output_names |
| 346 |
SET join_collapse_limit = DEFAULT; |
|
| 347 | 346 |
SET enable_hashjoin = off; |
| 348 | 347 |
SELECT DISTINCT taxon_scrub.scrubbed_unique_taxon_name AS tnrs_output_name |
| 349 | 348 |
FROM (taxonlabel |
| 350 | 349 |
JOIN "TNRS".taxon_scrub ON ((taxon_scrub."concatenatedScientificName" = taxonlabel.taxonomicname))) |
| 351 | 350 |
WHERE ((taxonlabel.source_id = ( SELECT source_by_shortname(:datasource::text) AS source_by_shortname)) AND (taxon_scrub."concatenatedScientificName" IS NOT NULL)); |
| 352 | 351 |
SET enable_hashjoin = DEFAULT; |
| 353 |
SET join_collapse_limit = 1; -- turn it off |
|
Also available in: Unified diff
validation/aggregating/plots/bien3_validations_salvias_vegbien.sql: _plots_21_tnrs_output_names: removed no longer needed setting of join_collapse_limit (the column now used does not involve an additional join)