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

From Hannu Krosing
Subject Re: use of / in ~ vs. ~*
Date
Msg-id 39D1944F.777ED0AE@tm.ee
Whole thread Raw
In response to use of / in ~ vs. ~*  (Hannu Krosing <hannu@tm.ee>)
Responses Re: use of / in ~ vs. ~*
List pgsql-hackers
Tom Lane wrote:
> 
> 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 ...


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


pgsql-hackers by date:

Previous
From: Magnus Hagander
Date:
Subject: RE: libpq static link library dowsn't work (M$ VS6)
Next
From: Hannu Krosing
Date:
Subject: Re: pgsql is 75 times faster with my new index scan