Project

General

Profile

« Previous | Next » 

Revision 13531

inputs/.TNRS/schema.sql: taxon_scrub: documented how to modify it

View differences:

vegbien.sql
17392 17392
--
17393 17393

  
17394 17394
COMMENT ON VIEW taxon_scrub IS '
17395
to update, use * as the column list
17395
to modify:
17396
SELECT "TNRS".taxon_scrub_modify($$
17397
 SELECT *
17398
   FROM "TNRS"."ValidMatchedTaxon"
17399
   LEFT JOIN "TNRS"."taxon_scrub.scrubbed_unique_taxon_name.*" USING (scrubbed_unique_taxon_name);
17400
$$);
17396 17401
';
17397 17402

  
17398 17403

  

Also available in: Unified diff