diff options
| -rw-r--r-- | sql/mlpdb.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/sql/mlpdb.sql b/sql/mlpdb.sql index ed4facd8..b4f0989c 100644 --- a/sql/mlpdb.sql +++ b/sql/mlpdb.sql @@ -166,7 +166,8 @@ CREATE OR REPLACE FUNCTION nameToBasketID(index_name varchar(4), p_date date) RE BEGIN
p_index := left(index_name, 2)::index_type;
p_series := right(index_name, -2);
- SELECT MAX(basketid) INTO p_basketid FROM index_desc WHERE Index=p_index and Series=p_series;
+ SELECT MIN(basketid) INTO p_basketid FROM index_version WHERE Index=p_index and
+ Series=p_series and lastdate>=p_date;
RETURN p_basketid;
END;
$$ LANGUAGE plpgsql;
|