Re: create function with dollar quoted body

Please provide actual Java code.

Florent

On Sat, Mar 10, 2012 at 8:13 PM, Jack Douglas
<jack(at)douglastechnology(dot)co(dot)uk> wrote:
> Hi
>> Please give a code example reproducing the problem you see.
> This works fine:
>
> create or replace function f() returns text language plpgsql as 'begin
> return ''A''; end;';
>
> But this fails with "unterminated dollar-quoted string":
>
> create or replace function f() returns text language plpgsql as $$begin
> return 'A'; end;$$;
>
> It is not a general problem with dollar-quoting because this works:
>
> create or replace function f() returns text language plpgsql as 'begin
> return $$A$$; end;';
>
> Thanks
> Jack
>

--
Florent Guillaume, Director of R&D, Nuxeo
Open Source, Java EE based, Enterprise Content Management (ECM)
http://www.nuxeo.com   http://www.nuxeo.org   +33 1 40 33 79 87