summaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorMarko Kreen2013-02-20 18:38:49 +0000
committerMarko Kreen2013-02-20 18:38:49 +0000
commit4632af45506278fca7ba4b3b9e3fb7d923fed357 (patch)
tree76fdbd4bd077029c541c84e7444fdf7d82d45edd /sql
parent2172e11bbc680b150429c6becb45696149fbeb71 (diff)
londiste.create_trigger: use decode for _new_args[1]
Diffstat (limited to 'sql')
-rw-r--r--sql/londiste/functions/londiste.create_trigger.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/sql/londiste/functions/londiste.create_trigger.sql b/sql/londiste/functions/londiste.create_trigger.sql
index dc2aac18..336460ed 100644
--- a/sql/londiste/functions/londiste.create_trigger.sql
+++ b/sql/londiste/functions/londiste.create_trigger.sql
@@ -187,7 +187,7 @@ begin
into _old_tgargs;
if found then
- _new_tgargs := lg_args[1];
+ _new_tgargs := decode(lg_args[1], 'escape');
for i in 2 .. array_upper(lg_args, 1) loop
_new_tgargs := _new_tgargs || E'\\000'::bytea || decode(lg_args[i], 'escape');
end loop;