Received: from mailin5.bigpond.com ([139.134.6.78]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f280eEx78810 for ; Wed, 7 Mar 2001 19:40:14 -0500 (EST) (envelope-from aa2@bigpond.net.au) Received: from bigpond.net.au ([139.134.4.51]) by mailin5.bigpond.com (Netscape Messaging Server 4.15) with SMTP id G9USPU01.6Y7; Thu, 8 Mar 2001 10:44:18 +1000 Received: from CPE-144-132-75-163.vic.bigpond.net.au ([144.132.75.163]) by mail7.bigpond.com (Claudes-Top-Fuel-MailRouter V2.9c 15/876072); 08 Mar 2001 10:39:45 Message-ID: <3AA6D462.BE90DA40@bigpond.net.au> Date: Thu, 08 Mar 2001 11:37:54 +1100 From: Justin Clift X-Mailer: Mozilla 4.76 [en] (X11; U; Linux 2.2.17-21mdk i686) X-Accept-Language: en MIME-Version: 1.0 To: Najm Hashmi CC: pgsql Subject: Re: quotes in pl/pgsql References: <3AA80DAE.2DF3F902@mondo-live.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200103/165 X-Sequence-Number: 1818 Hi Najm, Is this what you mean? CREATE FUNCTION foobar(int4) returns int4 as 'DECLARE textbuf varchar(120); BEGIN  textbuf := ''Example Text ''; insert into sometable (something) values (textbuf); RETURN 0; END;' LANGUAGE 'plpgsql'; Najm Hashmi wrote: > > Hi all, I just want to know how to put quotes around a string. Is there a > function to do so? > If not how can I escape a single quote. > Thank you in advance. > > ------------------------------------------------------------------------ > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org