| From: | "Graham Vickrage" <graham(at)digitalplanit(dot)com> |
|---|---|
| To: | "Postgres SQL" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | quotes nightmare! |
| Date: | 2002-02-22 13:18:51 |
| Message-ID: | NDBBJABDILOPAOOMFJHOGECGDEAA.graham@digitalplanit.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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'' '';
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Samuel J. Sutjiono | 2002-02-22 14:46:30 | How does Index Scan get used |
| Previous Message | Andre Holzner | 2002-02-22 09:17:12 | Re: Array slice subscripts (was Re: [SQL] plpgsql function |