Received: from brasileiro.net (slxwy.dorms.usu.edu [129.123.236.160]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fB2MNum44747 for ; Sun, 2 Dec 2001 17:23:56 -0500 (EST) (envelope-from roberto@brasileiro.net) Received: from roberto by brasileiro.net with local (Exim 3.33 #1 (Debian)) id 16Af2m-0006j2-00; Sun, 02 Dec 2001 15:25:04 -0700 Date: Sun, 2 Dec 2001 15:25:04 -0700 From: Roberto Mello To: Tom Lane Cc: Megalex , pgsql-sql@postgresql.org Subject: Re: problems with single quotes.. Message-ID: <20011202152504.B25485@cc.usu.edu> References: <20011201182212.R74581-100000@megazone23.bigpanda.com> <000b01c07680$29fb2430$0301a8c0@klanomega.com> <20966.1007305222@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=unknown-8bit Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <20966.1007305222@sss.pgh.pa.us> User-Agent: Mutt/1.3.23i X-Archive-Number: 200112/12 X-Sequence-Number: 5835 On Sun, Dec 02, 2001 at 10:00:22AM -0500, Tom Lane wrote: > > You're not counting/escaping your quotes correctly. That literal is > unterminated: > > ' opening quote > '' quoted quote (to put a quote in the string) > \' escaped quote (another way to do the same) > '' quoted quote > oops you're still inside the literal Section 24.5.1.1. Quote Me on That: Escaping Single Quotes http://www.postgresql.org/idocs/index.php?plpgsql-porting.html This should help. -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, Developer For Sale: Dehydrated H²O - $14 per quart