Re: Double-nesting quotes?

Carefully.  :)

Try: where_string := ''WHERE client_name ~* '''''' || s_client || '''''''';

(I think I got that right.)  The way I do it is to write it first as if
I'm not inside a function and not double my single quotes.  After I'm
done, go back and double all of them.. you're on you own if you need to
debug!

-Cedar


On Thu, 5 Apr 2001, Josh Berkus wrote:

> Folks,
> 
>     I'm writing some functions that make serious use of the EXECUTE
> functionality.  However, I need to do some string comparisons inside the
> execute statements ... how do I double-nest the single quote marks?
> 
> EXAMPLE:
> where_string := ''WHERE client_name ~* '''' || s_client || '''';
> 
>                     -Josh Berkus
> 
> ______AGLIO DATABASE SOLUTIONS___________________________
>                                        Josh Berkus
>   Complete information technology      josh@agliodbs.com
>    and data management solutions       (415) 565-7293
>   for law firms, small businesses        fax 621-2533
>     and non-profit organizations.      San Francisco
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>