diff options
| -rw-r--r-- | sql/modules/Settings.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/sql/modules/Settings.sql b/sql/modules/Settings.sql index b9c71dc8..eed89581 100644 --- a/sql/modules/Settings.sql +++ b/sql/modules/Settings.sql @@ -48,7 +48,7 @@ BEGIN WHERE setting_key = in_key FOR UPDATE; - SELECT substring(raw_value from '(\\d*)(\\D*|<\\?lsmb [^<>] \\?>)*$') + SELECT substring(raw_value from '(' || E'\\' || 'd*)(' || E'\\' || 'D*|<' || E'\\' || '?lsmb [^<>] ' || E'\\' || '?>)*$') INTO base_value; IF base_value like '0%' THEN |