1 files changed, 3 insertions, 8 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql
index 3563b344..e4a0e056 100644
--- a/sql/dawn.sql
+++ b/sql/dawn.sql
@@ -2139,20 +2139,15 @@ BEGIN
 END;
 $$ LANGUAGE plpgsql;
 
-CREATE OR REPLACE function latest_sim(p_date date) RETURNS integer AS $$
-DECLARE
-	id integer;
-BEGIN
-SELECT model_id_sub into id
+CREATE OR REPLACE function latest_sim(p_date timestamp) RETURNS integer AS $$
+SELECT model_id_sub
   FROM priced
   INNER JOIN model_versions USING (model_id_sub)
   INNER JOIN model_versions_nonagency USING (model_id_sub)
   INNER JOIN simulations_nonagency USING (simulation_id)
     WHERE description = 'normal' AND timestamp >= p_date
     LIMIT 1;
-RETURN id;
-End;
-$$ LANGUAGE plpgsql;
+$$ LANGUAGE SQL;
 
 CREATE OR REPLACE FUNCTION id_translate(VARIADIC id1 varchar(9)[])
 RETURNS TABLE(id2 varchar(12)) AS $$