aboutsummaryrefslogtreecommitdiffstats
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/serenitasdb.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/sql/serenitasdb.sql b/sql/serenitasdb.sql
index 5f520eac..6422df45 100644
--- a/sql/serenitasdb.sql
+++ b/sql/serenitasdb.sql
@@ -446,7 +446,7 @@ RETURNS TABLE(weight float, p_curve bytea) AS $$
SELECT nameToBasketID(index_name, p_date) INTO p_basketid;
RETURN QUERY SELECT curr_weight, curve FROM basket_constituents_current
LEFT JOIN cds_curves USING (company_id, seniority)
- WHERE basketid=p_basketid and date=p_date;
+ WHERE basketid=p_basketid and (date=p_date OR date IS NULL);
END;
$$ LANGUAGE plpgsql;