Re: Using backslash in query

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: Using backslash in query
Дата
Msg-id 004201c38a6b$0a888a00$6401a8c0@DUNSLANE
обсуждение исходный текст
Ответ на Using backslash in query  (Michael Brusser <michael@synchronicity.com>)
Ответы Re: Using backslash in query  (Andrew Dunstan <andrew@dunslane.net>)
Список pgsql-hackers
----- Original Message ----- 
From: "Hannu Krosing" <hannu@tm.ee>
>
> Regarding the dollar-quoting discussions -
>
> Will we be able to write the above query as
>
> SELECT smth. FROM  tbl WHERE WHERE situation LIKE $$%\\%$$;
>

Yes, as I understand it (as long as you remove the one of the WHEREs :-) ).
If not we need some rethinking.  Think of this as our equivalent of XML's
CDATA quoting - you don't need to escape & or < or > inside a CDATA node.


> in 7.4 or is \ still special there ?

I don't believe so.


cheers

andrew



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

Предыдущее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: Weird locking situation
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: Using backslash in query