From: Roberto Mello <rmello@cc.usu.edu>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Megalex <megalex@klanomega.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: problems with single quotes..
Date: Sun, 2 Dec 2001 15:25:04 -0700
Message-ID: <20011202152504.B25485@cc.usu.edu> (raw)
In-Reply-To: <20966.1007305222@sss.pgh.pa.us>
References: <20011201182212.R74581-100000@megazone23.bigpanda.com>
<000b01c07680$29fb2430$0301a8c0@klanomega.com>
<20966.1007305222@sss.pgh.pa.us>
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.nethttp://www.sdl.usu.edu - Space Dynamics Lab, Developer
For Sale: Dehydrated H²O - $14 per quart
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: rmello@cc.usu.edu, tgl@sss.pgh.pa.us, megalex@klanomega.com
Subject: Re: problems with single quotes..
In-Reply-To: <20011202152504.B25485@cc.usu.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox