Revision 5665
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.sql | ||
|---|---|---|
| 668 | 668 |
SELECT array_agg(ancestor_id) FROM taxonlabel_relationship |
| 669 | 669 |
WHERE descendant_id = parent_id_ |
| 670 | 670 |
); |
| 671 |
descendant_id_ integer;
|
|
| 671 |
descendant_id_ taxonlabel_relationship.descendant_id%TYPE;
|
|
| 672 | 672 |
ancestor_id_ taxonlabel_relationship.ancestor_id%TYPE; |
| 673 | 673 |
BEGIN |
| 674 | 674 |
FOR descendant_id_ IN -- also includes self |
Also available in: Unified diff
schemas/vegbien.sql: taxonlabel_update_ancestors(): Use aliased types (http://www.postgresql.org/docs/8.3/static/plpgsql-declarations.html#PLPGSQL-DECLARATION-TYPE) where possible