Revision 13442
Added by Aaron Marcuse-Kubitza over 10 years ago
public_.sql | ||
---|---|---|
9392 | 9392 |
CREATE VIEW _plots_20_tnrs_names AS |
9393 | 9393 |
SELECT taxonlabel.taxonomicname AS verbatim_name_with_author, |
9394 | 9394 |
taxonlabel.taxonomicname AS tnrs_input_name, |
9395 |
taxon_scrub.scrubbed_family AS tnrs_accepted_name_family,
|
|
9396 |
taxon_scrub.scrubbed_taxon_name_no_author AS tnrs_accepted_name,
|
|
9397 |
taxon_scrub.scrubbed_author AS tnrs_accepted_name_author,
|
|
9395 |
taxon_scrub.accepted_family AS tnrs_accepted_name_family,
|
|
9396 |
taxon_scrub.accepted_taxon_name_no_author AS tnrs_accepted_name,
|
|
9397 |
taxon_scrub.accepted_author AS tnrs_accepted_name_author,
|
|
9398 | 9398 |
taxon_scrub."morphospeciesSuffix" AS morphospecies_suffix |
9399 | 9399 |
FROM ((public.taxonverbatim |
9400 | 9400 |
JOIN public.taxonlabel USING (taxonlabel_id)) |
Also available in: Unified diff
bugfix: schemas/public_.sql: plots_20_tnrs_names: tnrs_accepted*: use new accepted_*, not scrubbed_*, as scrubbed_* does not contain only the accepted name (as implied by the tnrs_accepted_* column name)