Revision 14150
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/inputs/.TNRS/schema.sql | ||
|---|---|---|
| 196 | 196 |
AS $$ |
| 197 | 197 |
BEGIN |
| 198 | 198 |
new."__accepted_{genus,specific_epithet}" = (SELECT
|
| 199 |
regexp_split_to_array("*Accepted_name_species", ' ')
|
|
| 199 |
regexp_split_to_array("*Accepted_name_species", ' '::text)
|
|
| 200 | 200 |
FROM (SELECT new.*) new); |
| 201 | 201 |
|
| 202 | 202 |
RETURN new; |
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 19266 | 19266 |
AS $$ |
| 19267 | 19267 |
BEGIN |
| 19268 | 19268 |
new."__accepted_{genus,specific_epithet}" = (SELECT
|
| 19269 |
regexp_split_to_array("*Accepted_name_species", ' ')
|
|
| 19269 |
regexp_split_to_array("*Accepted_name_species", ' '::text)
|
|
| 19270 | 19270 |
FROM (SELECT new.*) new); |
| 19271 | 19271 |
|
| 19272 | 19272 |
RETURN new; |
Also available in: Unified diff
inputs/.TNRS/schema.sql: taxon_match__fill_derived(): updated using new util.derived_cols_sync()