From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
---|---|
To: | Graham Vickrage <graham(at)digitalplanit(dot)com> |
Cc: | Postgres SQL <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: quotes nightmare! |
Date: | 2002-02-22 16:11:34 |
Message-ID: | 20020222081109.Q35057-100000@megazone23.bigpanda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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(at)postgresql(dot)org)
>
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2002-02-22 16:13:02 | Re: How does Index Scan get used |
Previous Message | Roberto Mello | 2002-02-22 16:00:19 | Re: comparision chart |