Hannu Krosing writes:
> 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 locale the postmaster uses is whatever was set in its environment,
i.e., LC_ALL, etc.
--
Tom Lane wrote:
>
> 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 recen
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 ...
Can anyone explain why I must make / a character class
in case-insensitive query in order to match / ?
and then why does it work in plain ~ ?
hannu=> select * from item where path ~* '^/a';
path
--
/a/b/c
/a/b/d
/a/d/d
/aa/d
/a/b
/a/c
/a/d
(7 rows)
hannu=> select * from item wher
