view schema/updates/1001/01.simplify-get_schema_version.sql @ 5721:0500d76e074b uploadwg

Fixed eraseObsoleteGaugesSQL by reintroducing matching on users CC. The condition was removed when introducing file upload, but that leads to too many gauges being removed.
author Sascha Wilde <wilde@sha-bang.de>
date Fri, 19 Apr 2024 16:52:14 +0200
parents a2921151b193
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;
$$;