DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=OIKey9RDXplf4PXz/WHez4TMUqR0/Yn8tNN21b6PX5/D9cGWRJN3ah9R8Ygr8H4FcDgKmyM2QNMiyNz1GIC8Oi0VQ8FBxgzY1QZMzGhMvL1LP84RVOEA18V6dIDCNFZTZNbjiWbYqdmzG8f2x/veME/5rd0/XEHFrLiCdo91USI=
Message-ID: <a55915760705142325u33359969wef53e8bd20bdbc11@mail.gmail.com>
Date: Tue, 15 May 2007 01:25:25 -0500
From: "=?ISO-8859-1?Q?Rodrigo_De_Le=F3n?=" <rdeleonp@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: How to process inverted comma in "EXECUTE 'insert into xxx
	values(...)'; "?
Cc: "Nemo Terry" <ntuser155@hotmail.com>
In-Reply-To: <BAY19-F2416AC2716765516AB4824F53D0@phx.gbl>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <BAY19-F2416AC2716765516AB4824F53D0@phx.gbl>

On 5/14/07, Nemo Terry <ntuser155@hotmail.com> wrote:
> Look at this problem:
> when
> execute 'insert into lse_installations values(' || ''''||obj_id||'''' || ',' || ''''||div||'''' || ',' || ''''||sub||'''' || ',' || ''''||obj_type||'''' || ',' || ''''||obj_name||'''' || ',' || ''''||pstcd||'''' || ',' || ''''||rdcd||'''' || ',' || ''''||blkno||'''' || ',' || ''''||vldunt||'''' || ','|| cenlat || ',' || cenlon || ')';
> because obj_name from another table has value like this:S'pore High Polymer.
> Following error raises:
> ERROR: syntax error at or near "pore"
> SQL state: 42601
> Context: PL/pgSQL function "lse_installations" line 64 at execute statement
>
> So how to process the single inverted comma in char variable?It makes me so desperate.

Why are you EXECUTEing the INSERT command? It's directly supported in
plpgsql, since it is a superset of SQL. That is, you can do:

INSERT INTO lse_installations
     VALUES (obj_id, div, sub, obj_type, obj_name, pstcd, rdcd, blkno, vldunt
           , cenlat, cenlon);

Good luck.