Received: from mail1.hub.org (webmail.hub.org [216.126.85.1]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f8T4ZWO51219 for ; Sat, 29 Sep 2001 00:35:32 -0400 (EDT) (envelope-from wweng@kencast.com) Received: from nsx-a.snet.net ([204.60.203.54]) by mail1.hub.org (8.11.3/8.11.4) with ESMTP id f8SJdMS01072 for ; Fri, 28 Sep 2001 15:39:22 -0400 (EDT) (envelope-from wweng@kencast.com) Received: from pop.snet.net (pop.snet.net [204.60.6.9]) by nsx-a.snet.net (8.11.1/8.11.1/SNET-mx-1.4/D-1.10/O-1.7) with ESMTP id f8SJdbe24902 for ; Fri, 28 Sep 2001 15:39:37 -0400 (EDT) Received: from [192.168.1.83] (167.95.252.64.snet.net [64.252.95.167] (may be forged)) by pop.snet.net (8.11.1/8.11.1/SNET-pop-1.5/D-1.8/O-1.6) with ESMTP id f8SJdFL07628 for ; Fri, 28 Sep 2001 15:39:15 -0400 (EDT) Subject: What is wrong? From: Wei Weng To: pgsql-sql@postgresql.org Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Evolution/0.12 (Preview Release) Date: 28 Sep 2001 15:45:48 -0400 Message-Id: <1001706359.11935.4.camel@Monet> Mime-Version: 1.0 X-Archive-Number: 200109/269 X-Sequence-Number: 4951 Hi there. I wrote a simple postgresql sql function as follows: create function test() returns integer as ' begin fixed_path := translate (''/text'', ''\\'', ''/''); raise notice ''fixed_path:'', fixed_path; return 1; end ' language 'plpgsql'; And when I ran it as pgsql>select test(); I got: NOTICE: plpgsql: ERROR during compile of test near line 8 ERROR: unterminated string starting on line 10 What is wrong? (something fishy about translate function?) Could anyone enlighten me on this? Thank you very much! Wei