diff options
Diffstat (limited to 'sql/serenitasdb.sql')
| -rw-r--r-- | sql/serenitasdb.sql | 2 |
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;
|
