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

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

From
Martin Dolog
Date:
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

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