combining strings to make a query

Поиск
Список
Период
Сортировка
Искать
От
Wes James
Тема
combining strings to make a query
Дата
Msg-id
CAFjCMHtpbUh6Q-=aJmkC=XpTYVqiPUXkK9KYW09rcZLTYVgPig@mail.gmail.com
Список
Дерево обсуждения
combining strings to make a query Wes James <comptekki@gmail.com>
Re: combining strings to make a query Kevin Crain <kevin.crain1@gmail.com>
Re: combining strings to make a query Wes James <comptekki@gmail.com>
I'm using Erlang and postgresql to build a web interface.  When I
create the query string I get something like:

select * from table where field::text ilike '%\\\\%'

But when I do that (if someone types in '\' for part of the text
search), I get a pg log entry to use E'\\'

How would I use E'' with ilike '%%'.  ilike E'%\\%' doesn't work.

Thanks,

-wes

В списке pgsql-sql по дате отправления
От: Miguel Angel Conte
Дата:
Сообщение: Re: Max column number.
От: Kevin Crain
Дата:
Сообщение: Re: interesting sequence
FAQ