Received: from sss.pgh.pa.us (sss.pgh.pa.us [209.114.132.154]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eB14k8F49046 for ; Thu, 30 Nov 2000 23:46:08 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.1/8.11.1) with ESMTP id eB14kJY00419; Thu, 30 Nov 2000 23:46:19 -0500 (EST) To: "Jonathan Ellis" cc: pgsql-general@postgresql.org Subject: Re: pltcl: missing close-brace In-reply-to: <005301c05b30$be4318c0$0d00a8c0@dsl.inconnect.com> References: <5.0.2.1.2.20001130113826.082b4ec0@pop.mindspring.com><3A268A5C.91CB7353@wgcr.org> <14886.40191.455322.734798@onceler.kciLink.com> <017c01c05b05$5729dfa0$0d00a8c0@dsl.inconnect.com> <26096.975625542@sss.pgh.pa.us> <005301c05b30$be4318c0$0d00a8c0@dsl.inconnect.com> Comments: In-reply-to "Jonathan Ellis" message dated "Thu, 30 Nov 2000 17:50:47 -0700" Date: Thu, 30 Nov 2000 23:46:18 -0500 Message-ID: <415.975645978@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200011/1031 X-Sequence-Number: 1179 "Jonathan Ellis" writes: > I have a pl/tcl function that doesn't work, but the same function in a > plain-vanilla tcl script does. (The function emulates Oracle's "replace" > function.) > bf2=# create function replace2 (varchar, varchar, varchar) returns varchar > as ' > regsub -all {&} "$3" {\\\&} 3 > regsub -all {\\[0-9]} "$3" {\\\0} 3 > eval "regsub -all \{$2\} \{$1\} \{$3\} rval" > return $rval > ' language 'pltcl'; Those backslashes all need to be protected by backslashes ... the SQL parser will strip off one level of backslashing as it parses the command. regards, tom lane