From 81d4cc2c385f9871b1ced93cf3e1e258d56226e2 Mon Sep 17 00:00:00 2001 From: einhverfr Date: Thu, 28 Feb 2008 17:35:24 +0000 Subject: Moving Setting.sql to standard (if hard to read) escaping syntax git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2096 4979c152-3d1c-0410-bac9-87ea11338e46 --- sql/modules/Settings.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) 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 -- cgit v1.2.3