diff options
author | Étienne Loks <etienne.loks@iggdrasil.net> | 2017-01-12 11:21:00 +0100 |
---|---|---|
committer | Étienne Loks <etienne.loks@iggdrasil.net> | 2017-01-12 11:21:00 +0100 |
commit | ebce71ee6d96820ebebccc912d4636d04278fed3 (patch) | |
tree | 5c58fdd688f37d475e184e22e14aad71e8d84f4a | |
parent | 4c29676b6299629a13ec9f7ef077df56b48f5f0b (diff) | |
download | Ishtar-ebce71ee6d96820ebebccc912d4636d04278fed3.tar.bz2 Ishtar-ebce71ee6d96820ebebccc912d4636d04278fed3.zip |
Fix treatment views (cardinality is not array_upper)
-rw-r--r-- | archaeological_finds/models_treatments.py | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/archaeological_finds/models_treatments.py b/archaeological_finds/models_treatments.py index 945ff57d4..90badcd35 100644 --- a/archaeological_finds/models_treatments.py +++ b/archaeological_finds/models_treatments.py @@ -319,7 +319,7 @@ class FindUpstreamTreatments(AbsFindTreatments): JOIN rel_tree p ON c.upstream_treatment_id = p.downstream_treatment_id AND c.upstream_treatment_id != - ALL(p.path_info[0:cardinality(p.path_info)-1]) + ALL(p.path_info[0:array_upper(p.path_info, 1)-1]) ) SELECT DISTINCT find_id, path_info, level FROM rel_tree ORDER BY find_id; @@ -373,7 +373,7 @@ class FindDownstreamTreatments(AbsFindTreatments): JOIN rel_tree p ON c.downstream_treatment_id = p.upstream_treatment_id AND c.downstream_treatment_id != - ALL(p.path_info[0:cardinality(p.path_info)-1]) + ALL(p.path_info[0:array_upper(p.path_info, 1)-1]) ) SELECT DISTINCT find_id, path_info, level FROM rel_tree ORDER BY find_id; |