Postgres 8.4 literal escaping

Поиск
Список
Период
Сортировка
От Niederland
Тема Postgres 8.4 literal escaping
Дата
Msg-id ff1a179c-b184-4bb3-9cbb-afc2f8ca5550@k19g2000yqn.googlegroups.com
обсуждение исходный текст
Ответы Re: Postgres 8.4 literal escaping
Список pgsql-general
with Postgres 8.4:

SQL 1: update customer set note = ('A' || '\r\n' || 'B') where 1=0;

generates:
WARNING:  nonstandard use of escape in a string literal
LINE 1: update customer set note = ('A' || '\r\n' || 'B') where 1=0;
                                           ^
HINT:  Use the escape string syntax for escapes, e.g., E'\r\n'.
(Note is of datatype TEXT)

SQL 2: select ('A' || '\r\n' || 'B') as tt from customer limit 1
Functions without escaping literal

On postgres 8.3.7 both of the above SQLs function without requiring
any literals to be escaped.

This seems inconsistent to me in that I would have thought that in
Postgres 8.4 either both SQLs would have required escaping or neither
of them would have required escaping.


В списке pgsql-general по дате отправления:

Предыдущее
От: "Roseller A. Romanos"
Дата:
Сообщение: Help me please...
Следующее
От: Tim Keitt
Дата:
Сообщение: Overhead of union versus union all