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 '
BEGINEXECUTE ''CREATE FUNCTION _test'' || $1 || '' () RETURNS int AS ''BEGIN RAISE EXCEPTION ''Help'';RETURN
2;END'';LANGUAGE ''plpgsql'' '';
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.