Re: Postgres 8.4 literal escaping - Mailing list pgsql-general

Niederland <niederland@gmail.com> writes:
> SQL 2: select ('A' || '\r\n' || 'B') as tt from customer limit 1
> Functions without escaping literal

Really?  I get

regression=# select ('A' || '\r\n' || 'B') as tt from customer limit 1;
WARNING:  nonstandard use of escape in a string literal
LINE 1: select ('A' || '\r\n' || 'B') as tt from customer limit 1;
                       ^
HINT:  Use the escape string syntax for escapes, e.g., E'\r\n'.
 tt
----
(0 rows)

            regards, tom lane