Re: use of / in ~ vs. ~* - Mailing list pgsql-hackers

From Tom Lane
Subject Re: use of / in ~ vs. ~*
Date
Msg-id 5155.970013197@sss.pgh.pa.us
Whole thread Raw
In response to use of / in ~ vs. ~*  (Hannu Krosing <hannu@tm.ee>)
List pgsql-hackers
Hannu Krosing <hannu@tm.ee> 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


pgsql-hackers by date:

Previous
From: "Mikheev, Vadim"
Date:
Subject: RE: RE: [GENERAL] update inside transaction violates un ique constraint?
Next
From: "Mikheev, Vadim"
Date:
Subject: RE: RE: [GENERAL] update inside transaction violates un ique constraint?