Mercurial > gemma

diff schema/gemma.sql @ 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 7b7c324b318f
children 3dc2694557f1
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;
 $$;