Niederland <niederland@xxxxxxxxx> 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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
