Re: word search

Поиск
Список
Период
Сортировка
От Wim Ceulemans
Тема Re: word search
Дата
Msg-id 38E99CB7.C59E446C@nice.be
обсуждение исходный текст
Ответ на word search  ("Cédric Prévost" <cedric_prevost@hotmail.com>)
Список pgsql-general
"Cédric Prévost" wrote:
>
> Hello,
>
> I would like to proceed to word search in a table.
> Use of "[...] attribute~*'string';" in the condition were fine. However,
> presence of operators within the string give me an error.
> For example :
> [...] attribute~*'C++';
> To unspecialise the operators could be a way of solving this.
> Do you know to do that, if it is possible ?
> Thanks for you help,
>

Make sure the result to the backend is:

[...] attribute ~* 'C\\+\\+';

(escape the special characters)

Wim

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

Предыдущее
От: JB
Дата:
Сообщение: Re: SELECT speed with LIKE
Следующее
От: Jim Richards
Дата:
Сообщение: Re: SELECT speed with LIKE