Project

General

Profile

« Previous | Next » 

Revision 13440

bugfix: schemas/public_.sql: _plots_20_tnrs_names: morphospeciesSuffix must still be called morphospecies_suffix, not taxon_morphospecies, because that column has not been updated to the taxon_morphospecies yet (fixes r13435)

View differences:

trunk/schemas/public_.sql
9395 9395
    taxon_scrub.scrubbed_family AS tnrs_accepted_name_family, 
9396 9396
    taxon_scrub.scrubbed_taxon_name_no_author AS tnrs_accepted_name, 
9397 9397
    taxon_scrub.scrubbed_author AS tnrs_accepted_name_author, 
9398
    taxon_scrub."morphospeciesSuffix" AS taxon_morphospecies
9398
    taxon_scrub."morphospeciesSuffix" AS morphospecies_suffix
9399 9399
   FROM ((public.taxonverbatim
9400 9400
   JOIN public.taxonlabel USING (taxonlabel_id))
9401 9401
   JOIN "TNRS".taxon_scrub ON ((taxon_scrub."concatenatedScientificName" = taxonlabel.taxonomicname)))
trunk/schemas/vegbien.sql
9395 9395
    taxon_scrub.scrubbed_family AS tnrs_accepted_name_family, 
9396 9396
    taxon_scrub.scrubbed_taxon_name_no_author AS tnrs_accepted_name, 
9397 9397
    taxon_scrub.scrubbed_author AS tnrs_accepted_name_author, 
9398
    taxon_scrub."morphospeciesSuffix" AS taxon_morphospecies
9398
    taxon_scrub."morphospeciesSuffix" AS morphospecies_suffix
9399 9399
   FROM ((public.taxonverbatim
9400 9400
   JOIN public.taxonlabel USING (taxonlabel_id))
9401 9401
   JOIN "TNRS".taxon_scrub ON ((taxon_scrub."concatenatedScientificName" = taxonlabel.taxonomicname)))

Also available in: Unified diff