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