[SQL] select ... from ... where ... ~* 'C++'

Поиск
Список
Период
Сортировка
От Martin Dolog
Тема [SQL] select ... from ... where ... ~* 'C++'
Дата
Msg-id 37D12DB8.F94227A3@mcprogress.com
обсуждение исходный текст
Ответы Re: [SQL] select ... from ... where ... ~* 'C++'
Список pgsql-sql
hi *,

PLease, how can I make case insensitive query
which work with string like 'C++' too ?

select something from something_t where some ~* 'C++'

doesn't work!
I got following error message:

"ERROR:  regcomp failed with error repetition-operator operand invalid"


I am running on Linux/Redhat6/postgresql6.5 compiled
with --enable-locale flag.


Thank you very much for help.


Martin

-- 

#md

************




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