# HG changeset patch
# User Sascha Wilde <wilde@intevation.de>
# Date 1563374906 -7200
# Node ID a2921151b193f211b307021b36ea1385e991b32f
# Parent  074cf9349c716d70885a21ce65ae495f9ff552bc
Schema: Use SQL instead of PLPGSQL for get_schema_version().

diff -r 074cf9349c71 -r a2921151b193 schema/gemma.sql
--- a/schema/gemma.sql	Wed Jul 17 16:40:29 2019 +0200
+++ b/schema/gemma.sql	Wed Jul 17 16:48:26 2019 +0200
@@ -214,11 +214,9 @@
 );
 
 CREATE OR REPLACE FUNCTION get_schema_version() RETURNS int
-    LANGUAGE plpgsql
+    LANGUAGE sql
     AS $$
-    BEGIN
-        RETURN ( SELECT max(version) FROM gemma_schema_version );
-    END;
+    SELECT max(version) FROM gemma_schema_version;
 $$;
 
 
diff -r 074cf9349c71 -r a2921151b193 schema/updates/1001/01.simplify-get_schema_version.sql
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/schema/updates/1001/01.simplify-get_schema_version.sql	Wed Jul 17 16:48:26 2019 +0200
@@ -0,0 +1,5 @@
+CREATE OR REPLACE FUNCTION get_schema_version() RETURNS int
+    LANGUAGE sql
+    AS $$
+    SELECT max(version) FROM gemma_schema_version;
+$$;