Re: BUG #4908: escaping and dollar quotes: "ERROR: unterminated string" - Mailing list pgsql-bugs

Tom Lane <tgl@sss.pgh.pa.us> 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
-----------------------------------------------------------------------------------------------------
 PostgreSQL 8.3.7 on x86_64-unknown-linux-gnu, compiled by GCC gcc
(GCC) 4.1.2 20070115 (SUSE Linux)
(1 row)

ccdev=> show standard_conforming_strings ;
 standard_conforming_strings
-----------------------------
 on
(1 row)

ccdev=> create or replace function temp() returns text language
plpgsql
AS $$
begin
  return '\';
end; $$;
ERROR:  unterminated string
CONTEXT:  compile of PL/pgSQL function "temp" near line 2

-Kevin