Re: Need help with EXECUTE function - Mailing list pgsql-sql

From Cedar Cox
Subject Re: Need help with EXECUTE function
Date
Msg-id Pine.LNX.4.21.0104090254090.7547-300000@nanu.visionforisrael.com
Whole thread Raw
In response to Need help with EXECUTE function  ("Josh Berkus" <josh@agliodbs.com>)
List pgsql-sql
Attached is the (I think) corrected version..  If you do like I said and
cut the number in half you see fairly quickly why it didn't work.  I'm
sending yours back so you can easily run a diff to see what I did.  Let me
know if this (attached "cedars") works.

-Cedar

On Sat, 7 Apr 2001, Josh Berkus wrote:

> Folks (esp Jan, Tom & Michael):
> 
> I have a search function I'm testing, which uses the EXECUTE function to
> perform a dynamic set of string comparisons according to whcih criteria
> the user passes along.  Unfortunately, this requires me to triple-nest
> my quotes .... and I can't seem to get it right.  No matter how I play
> with the function, it keeps blowing up due to "unterminated strings".
> This happens even if I terminate the function short of the EXECUTE
> statement.
> 
> Can someone *please* give me some pointers?
> 
> Function text:
> 
*snip*

pgsql-sql by date:

Previous
From: Cedar Cox
Date:
Subject: Re: Casting numeric to text
Next
From: Cedar Cox
Date:
Subject: Re: Double-nesting quotes?