Mercurial > gemma

comparison 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
comparison
equal deleted inserted replaced
3995:074cf9349c71 3996:a2921151b193
212 version int PRIMARY KEY, 212 version int PRIMARY KEY,
213 update_date timestamp with time zone NOT NULL DEFAULT CURRENT_TIMESTAMP 213 update_date timestamp with time zone NOT NULL DEFAULT CURRENT_TIMESTAMP
214 ); 214 );
215 215
216 CREATE OR REPLACE FUNCTION get_schema_version() RETURNS int 216 CREATE OR REPLACE FUNCTION get_schema_version() RETURNS int
217 LANGUAGE plpgsql 217 LANGUAGE sql
218 AS $$ 218 AS $$
219 BEGIN 219 SELECT max(version) FROM gemma_schema_version;
220 RETURN ( SELECT max(version) FROM gemma_schema_version );
221 END;
222 $$; 220 $$;
223 221
224 222
225 -- 223 --
226 -- GEMMA data 224 -- GEMMA data