Revision 5512
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/tree_cross-links.sql | ||
|---|---|---|
| 42 | 42 |
SET taxonconcept_id = taxonconcept_id -- need at least one SET statement |
| 43 | 43 |
-- Add COALESCE() to enable using taxonconcept_unique index for lookup |
| 44 | 44 |
WHERE COALESCE(parent_id, 2147483647) = new.taxonconcept_id |
| 45 |
AND taxonconcept_id != new.taxonconcept_id -- avoid infinite recursion |
|
| 45 | 46 |
; |
| 46 | 47 |
|
| 47 | 48 |
/* Note: We don't need an ON DELETE trigger to update the descendants' |
Also available in: Unified diff
schemas/vegbien.sql: *_update_ancestors(): Telling immediate children to update their ancestors lists: Exclude self to avoid infinite recursion