Mercurial > gemma
changeset 937:72430f050d90
Improve error message for isrs_fromText
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Mon, 08 Oct 2018 19:48:51 +0200 |
parents | f27fe4e9bfd9 |
children | fe923c8ef08f |
files | schema/isrs.sql |
diffstat | 1 files changed, 2 insertions(+), 1 deletions(-) [+] |
line wrap: on
line diff
--- a/schema/isrs.sql Mon Oct 08 18:09:28 2018 +0200 +++ b/schema/isrs.sql Mon Oct 08 19:48:51 2018 +0200 @@ -39,7 +39,8 @@ IF char_length(isrs_text) <> isrs_len THEN RAISE 'ISRS location code must be % characters long', isrs_len - USING ERRCODE = 'invalid_parameter_value'; + USING ERRCODE = 'invalid_parameter_value', + DETAIL = 'Failing value: ' || isrs_text; ELSE RETURN CAST(( substring(isrs_text from 1 for 2),