backslashes in queries containing LIKE

Поиск
Список
Период
Сортировка
Искать
От
Mickael Faivre-Macon
Тема
backslashes in queries containing LIKE
Дата
Msg-id
f132f7e30501260544197a9e1d@mail.gmail.com
Список
Дерево обсуждения
Re: backslashes in queries containing LIKE Michael Fuhr <mike@fuhr.org>
Re: backslashes in queries containing LIKE Mickael Faivre-Macon <faivrem@gmail.com>
Hi,

We have a problem with backslashes in queries containing LIKE.

insert into table (field) values ('IM\\test')
select * from table where field = 'IM\\test'

returns one record

select * from table where field LIKE 'IM\\%'

returns no record

Why is postgres behaves like that ?
Can someone help us ?

Scripts for testing purpose have been attached.

Mickael Faivre-Macon.
В списке pgsql-general по дате отправления
От: Carlos Oliva
Дата:
От: Frank D. Engel, Jr.
Дата:
Сообщение: Re: Extended unit
FAQ