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