Mercurial > gemma

changeset 3730:d9ac1c56bfe0

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Make isrs_fromText case insensitive.
author Sascha Wilde <wilde@intevation.de>
date Mon, 24 Jun 2019 11:20:34 +0200
parents 9fa108794e21
children 0d45a3c34900
files schema/isrs.sql
diffstat 1 files changed, 1 insertions(+), 0 deletions(-) [+]
line wrap: on
line diff
--- a/schema/isrs.sql	Thu Jun 20 19:43:25 2019 +0200
+++ b/schema/isrs.sql	Mon Jun 24 11:20:34 2019 +0200
@@ -154,6 +154,7 @@
 DECLARE
     isrs_len CONSTANT int = 20;
 BEGIN
+    isrs_text = upper(isrs_text);
     IF char_length(isrs_text) <> isrs_len
     THEN
         RAISE 'ISRS location code must be % characters long', isrs_len