Niederland <niederland(at)gmail(dot)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