Mercurial > gemma
changeset 3730:d9ac1c56bfe0
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