Received: from fslc.usu.edu (fslc.usu.edu [129.123.2.40]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f28145x66319 for ; Wed, 7 Mar 2001 20:04:05 -0500 (EST) (envelope-from rmello@fslc.usu.edu) Received: (from rmello@localhost) by fslc.usu.edu (8.11.3/8.11.3/Debian 8.11.2-1) id f2813sk20127; Wed, 7 Mar 2001 18:03:54 -0700 Date: Wed, 7 Mar 2001 18:03:54 -0700 From: Roberto Mello To: Najm Hashmi Cc: pgsql Subject: Re: quotes in pl/pgsql Message-ID: <20010307180354.A20006@cc.usu.edu> References: <3AA80DAE.2DF3F902@mondo-live.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.3.15i In-Reply-To: <3AA80DAE.2DF3F902@mondo-live.com>; from najm@mondo-live.com on Thu, Mar 08, 2001 at 05:54:38PM -0500 X-Archive-Number: 200103/166 X-Sequence-Number: 1819 On Thu, Mar 08, 2001 at 05:54:38PM -0500, 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. Others have answered how to quote a single string. I wrote an entire section on quotes on the PL/SQL-to-PL/pgSQL-HOWTO. It's called "Quote me on that" and mentions several cases on quote usage in PL/pgSQL and what to do about it. http://www.brasileiro.net/roberto/howto -Roberto -- +----| http://fslc.usu.edu USU Free Software & GNU/Linux Club|------+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net http://www.sdl.usu.edu - Space Dynamics Lab, Web Developer DOS = Damned Old Software