Mercurial > gemma
changeset 3996:a2921151b193
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; $$;