Re: Single quote instead of double?

Thanks for your swift response.

You are suggesting that after I create the query string, I edit it to
substitute single quote with double, then execute the query. I agree
this is a trivial solution, I wanted to know if there is an elegant
way, say by some switches or something...

Have a nice day.

On Saturday, March 15, 2003, at 01:35 PM, Vernon Wu wrote:

> You need to pad a backslash in front of the apostrophe, or double up
> the apostrophe. Here is an example code:
>
> int k=0;
> while((k = src.indexOf("'", k)) >= 0) {
> src = src.substring(0, k) + "\\" + src.substring(k);
> k += 2;
> }
> return src;
> *
>
> 15/03/2003 10:28:10 AM, Oguz Imre <maccube(at)comcast(dot)net> wrote:
>
>
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>