nonstandard use of

Поиск
Список
Период
Сортировка
От Peckham, Martin
Тема nonstandard use of
Дата
Msg-id 7CDAD19EDE01F84DA8E5F91031C715AC490D65@GS-EXCH2.guidancesoftware.com
обсуждение исходный текст
Ответы Re: nonstandard use of  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
Список pgsql-general

I recently installed the latest non-beta version 8.2 of postgresql.

 

I get the following warning and hint in the server status GUI:

 

WARNING:    nonstandard use of \\ in a string literal at characters 64

HINT:       Use the excape string syntax for backslashes, e.g, E’\\’.

 

The “raw” string I want to write is:

 

[\x09-\x0A\x0D\x20-\x2F\x3A-\x40\x5B-\x60\x7B-\x7E]MI[\x09-\x0A\x0D\x20-\x2F\x3A-\x40\x5B-\x60\x7B-\x7E]

 

After escaping, I write:                                          _ 64th

                                                                 /

[\\x09-\\x0A\\x0D\\x20-\\x2F\\x3A-\\x40\\x5B-\\x60\\x7B-\\x7E]MI[\\x09-\\x0A\\x0D\\x20-\\x2F\\x3A-\\x40\\x5B-\\x60\\x7B-\\x7E]

 

Assuming the count starts at 0, the character at position 64 is the [ character.

 

I’ve read an earlier post that tells of how to SUPRESS the warning.  I want to eliminate the warning.

 

TIA

 

Marty Peckham

 

Note: The information contained in this message may be privileged and
confidential and thus protected from disclosure. If the reader of this
message is not the intended recipient, or an employee or agent responsible 
for delivering this message to the intended recipient, you are hereby
notified that any dissemination, distribution or copying of this
communication is strictly prohibited.  If you have received this
communication in error, please notify us immediately by replying to the 
message and deleting it from your computer.  Thank you.

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

Предыдущее
От: Reg Me Please
Дата:
Сообщение: Re: [PGSQL v8.2.5] Similar queries behave differently
Следующее
От: kamiseq
Дата:
Сообщение: function and passing the table name to be used with SQL stmnt