aboutsummaryrefslogtreecommitdiffstats
path: root/sql/mlpdb.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql/mlpdb.sql')
-rw-r--r--sql/mlpdb.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/sql/mlpdb.sql b/sql/mlpdb.sql
index 3bf72394..02f69961 100644
--- a/sql/mlpdb.sql
+++ b/sql/mlpdb.sql
@@ -180,8 +180,8 @@ CREATE OR REPLACE FUNCTION index_members(index_name varchar(4), p_date date)
CREATE OR REPLACE FUNCTION historical_cds_quotes(date) RETURNS SETOF cds_quotes AS $$
BEGIN
RETURN QUERY SELECT b.*
- FROM (SELECT max(c.Date) AS latestdate, c.curve_ticker FROM cds_quotes c
- WHERE c.Date<=$1 GROUP BY c.curve_ticker) a
+ FROM (SELECT min(c.Date) AS latestdate, c.curve_ticker FROM cds_quotes c
+ WHERE c.Date>=$1 GROUP BY c.curve_ticker) a
JOIN cds_quotes b ON a.curve_ticker = b.curve_ticker AND a.latestdate=b.Date;
END;
$$ LANGUAGE plpgsql;