Re: quotes nightmare!

On Fri, 22 Feb 2002, Graham Vickrage wrote:

> I am having trouble with my quotes in a function and think I have tried
> every comb (obviously not) as it does not work:
>
> I am trying to create a function within a function passing the second
> function into the first as a parameter as follows:-
>
> CREATE FUNCTION _test(text) RETURNS int AS '
> BEGIN
>     EXECUTE ''
>     CREATE FUNCTION _test'' || $1 || '' () RETURNS int AS ''
>     BEGIN
>         RAISE EXCEPTION ''Help'';
>     RETURN 2;
>     END''; LANGUAGE ''plpgsql'' '';
shouldn't that first semicolon be inside the '' with the end?

> RETURN 1;
> END;'
> LANGUAGE 'plpgsql';
>
> SELECT _test('ing');
>
> Could anyone tell me which bit is causing the problem as I am now completely
> lost, the error message mentions is near LANGUAGE.
>
> Many thanks
>
> Graham.
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>