Revision 6068
Added by Aaron Marcuse-Kubitza over 11 years ago
schemas/vegbien.sql | ||
---|---|---|
431 | 431 |
CREATE FUNCTION _taxon_family_require_std(family text) RETURNS text |
432 | 432 |
LANGUAGE sql IMMUTABLE STRICT |
433 | 433 |
AS $_$ |
434 |
SELECT (CASE WHEN $1 LIKE '%aceae' THEN $1 ELSE NULL END)
|
|
434 |
SELECT (CASE WHEN lower($1) LIKE '%aceae' THEN $1 ELSE NULL END)
|
|
435 | 435 |
$_$; |
436 | 436 |
|
437 | 437 |
|
Also available in: Unified diff
schemas/vegbien.sql: _taxon_family_require_std(): Fixed bug where name needed to be lowercased before checking if it ended in -aceae, to support family names that are uppercase. Note that this resulted in the family not being prepended to the TNRS input name for datasources with uppercase family names, so the next DB import will likely produce a number of unscrubbed TNRS input names which now have the uppercase family prepended.