Received: from marketingchallenge.com (marketingchallenge.com [64.40.111.205] (may be forged)) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f27NUix60347 for ; Wed, 7 Mar 2001 18:30:46 -0500 (EST) (envelope-from drfrog@smartt.com) Received: (qmail 31914 invoked from network); 7 Mar 2001 23:30:30 -0000 Received: from clayton-cottingham.imc (HELO smartt.com) (drfrog@10.1.4.1) by marketingchallenge.com with SMTP; 7 Mar 2001 23:30:30 -0000 Message-ID: <3AA6C50B.2BCA7E52@smartt.com> Date: Wed, 07 Mar 2001 15:32:27 -0800 From: clayton cottingham 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/163 X-Sequence-Number: 1816 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 single qutoe escaping : 'here''s johnny'