Mercurial > gemma

view schema/updates/1001/01.simplify-get_schema_version.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
children
line wrap: on
line source

CREATE OR REPLACE FUNCTION get_schema_version() RETURNS int
    LANGUAGE sql
    AS $$
    SELECT max(version) FROM gemma_schema_version;
$$;