WARNING: nonstandard use of escape in a string literal

Поиск
Список
Период
Сортировка
От Patrick M. Rutkowski
Тема WARNING: nonstandard use of escape in a string literal
Дата
Msg-id c4b204920912231212v5e82c48ep90114ee0b9561f8d@mail.gmail.com
обсуждение исходный текст
Ответы Re: WARNING: nonstandard use of escape in a string literal  (Bill Moran <wmoran@potentialtech.com>)
Список pgsql-general
I just ran something like:
=============================================
UPDATE my_table SET colname = NULL WHERE colname ~ '^\s*$'
=============================================


I got the following warnings/hints as a result:
=============================================
WARNING: nonstandard use of escape in a string literal
HINT: USE the escape string syntax for escapes, e.g., E'\r\n'.
UPDATE 500
=============================================


Oddly it actually updated, and did just exactly what I wanted! :-)

So what am I to make of those weird hints and warning?

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

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: How to get a list of tables that have a particular column value?
Следующее
От: Christophe Pettus
Дата:
Сообщение: 12/08 SFPUG meeting, "Operator Exclusion Constraints," video now available