> The function body contains
> return '\';
>
> and that string literal causes a syntax error when we come to parse the
> RETURN statement.
Thanks for the explanation - very clear.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://
"Kevin Grittner" writes:
> Tom Lane wrote:
>> Or you could turn on standard_conforming_strings if you'd prefer not
>> to deal with escapes.
> That doesn't help with this, because of the separate pgpgsql parser:
Ah, sorry, it does work in 8.4 but not before.
regards, t
Tom Lane wrote:
> Or you could turn on standard_conforming_strings if you'd prefer not
> to deal with escapes.
That doesn't help with this, because of the separate pgpgsql parser:
ccdev=> select version();
version
--
"Jack Douglas" writes:
> Am I missing something obvious here - I understand from the documentation no
> escapes are counted in dollar quoted strings?
Yes, and yes.
> postgres=> create or replace function temp() returns text language plpgsql
> AS $$
> postgres$> begin
> postgres$> return '\';
>
