Re: [HACKERS] use of / in ~ vs. ~*

[Tom Lane]

Hannu Krosing <[EMAIL PROTECTED]> writes:
> Can anyone explain why I must make / a character class 
> in case-insensitive query in order to match / ?

What LOCALE are you using?  There was a thread about strange ordering
rules confusing the LIKE/regexp optimizer recently ...

                        regards, tom lane