Mercurial > gemma

changeset 3996:a2921151b193

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Schema: Use SQL instead of PLPGSQL for get_schema_version().
author Sascha Wilde <wilde@intevation.de>
date Wed, 17 Jul 2019 16:48:26 +0200
parents 074cf9349c71
children 78c9aef329cd
files schema/gemma.sql schema/updates/1001/01.simplify-get_schema_version.sql
diffstat 2 files changed, 7 insertions(+), 4 deletions(-) [+]
line wrap: on
line diff
--- 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;
 $$;
 
 
--- /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;
+$$;