Tom Lane wrote:
>
> Hannu Krosing <hannu(at)tm(dot)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 ...
I think I'm using the default locale (this is just straight install on
Linux from RPM-s)
Is there any way to find out the locale used from within the running
system ?
The most obvious way ( select locale(); ) does not work .
-----------
Hannu