Re: quotes nightmare!

On Fri, Feb 22, 2002 at 01:18:51PM +0000, Graham Vickrage wrote:
> BEGIN
>     EXECUTE ''
>     CREATE FUNCTION _test'' || $1 || '' () RETURNS int AS ''

When you enter these '' you are ending the EXECUTE block. If you don't
want to end thit EXECUTE block, then you have to espace each of these
quotes.

> Could anyone tell me which bit is causing the problem as I am now completely
> lost, the error message mentions is near LANGUAGE.

You should look at:

http://www.postgresql.org/idocs/index.php?plpgsql-porting.html#PLPGSQL-QUOTING-TABLE
http://www.postgresql.org/idocs/index.php?plpgsql-porting.html#PLPGSQL-PORTING-NASTYQUOTE

-Roberto

-- 
+----| http://fslc.usu.edu/ USU Free Software & GNU/Linux Club |------+ Roberto Mello - Computer Science, USU -
http://www.brasileiro.net/      http://www.sdl.usu.edu/ - Space Dynamics Lab, Developer    
 
Advisor: The guy who told you how to screw up