diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/dawn.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index 39eb021c..b95026be 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -152,11 +152,11 @@ RETURNS TABLE(identifier varchar(12), description varchar(32), mark float, delta undiscounted_price float, model_price float) AS $$ BEGIN RETURN QUERY SELECT a.identifier, a.description, b.price, c.delta, c.index_delta, - c.duration, c.wal, c_undiscounted_price, c.model_price + c.duration, c.wal, c.undiscounted_price, c.model_price FROM list_positions(p_date, assetclass, include_unsettled) a LEFT JOIN (SELECT DISTINCT ON (identifier) date, marks.identifier, marks.price FROM marks WHERE date<= p_date ORDER BY identifier, date DESC) b USING (identifier) - LEFT JOIN (SELECT DISTINCT ON (identifier) * FROM risk_number + LEFT JOIN (SELECT DISTINCT ON (identifier) * FROM risk_numbers WHERE date<=p_date ORDER BY identifier, date DESC) c USING (identifier); END; $$ LANGUAGE plpgsql; |