Re: [SQL] Backslash characters in PLPGSQL

2010-08-03 Thread Tom Lane
"Garrett Murphy" writes: > We recently upgraded from 8.3 to 8.4 and are noticing a change in > behavior that we can't seem to associate with a particular server > setting. I think you're seeing the effects of this 8.4 patch: http://archives.postgresql.org/pgsql-committers/2009-04/msg00216.php in

[SQL] Backslash characters in PLPGSQL

2010-08-03 Thread Garrett Murphy
We recently upgraded from 8.3 to 8.4 and are noticing a change in behavior that we can't seem to associate with a particular server setting. In 8.3, the following compiles and works perfectly: CREATE OR REPLACE FUNCTION test_function2(tText TEXT) RETURNS TEXT AS $BODY$ BEGIN