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

Martin,

Try

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

or rather,

select something from something_t where some like '%C++%'

Troy


>
>
> 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
>
> ************
>
>