Re: [BUGS] BUG #4027: backslash escaping not disabled inplpgsql

Bruce Momjian <bruce@momjian.us> wrote:
> standard_conforming_strings was added in Postgres 8.1, and
> escape_string_warning was enabled in 8.2.
 
Other way around -- the warning was available in 8.1; the standard
character string literals were available in 8.2.

> I think the big issue is that having standard_conforming_strings
> affect function behavior introduces the same problems we have had in
> the past of having a GUC affect function behavior.
 
Can't that be managed with this CREATE FUNCTION option?:
 
SET configuration_parameter { TO value | = value | FROM CURRENT }
 
I would like to see standard character string literals at least
available in PL/pgSQL, although I don't personally care whether it is
the default or whether I need to specify it with the above option. 
Might it not confuse people to have this GUC behave differently than
others, though?
 
-Kevin