Re: [HACKERS] Bug in index scans with Locale support enabled

Barry Lind writes:

> The reason for this is that in the en_US locale all non-alphanumeric
> characters are ignored when doing string comparisons. So the data above
> gets treated as:
> abc.xyz = abcxyz = abc/xyz (as the non-alphanumeric characters of '.'
> and '/' are ignored). This implys that the above query will then return
> all rows as the constant 'abc.' is the same as 'abc' for comparison
> purposes and all rows are >= 'abc'.
>
> Note that if you use a different locale for example en_UK, you will get
> different results as this locale does not ignore the . and / in the
> comparison.

The reason for that is that en_UK is not a valid locale name and will get
treated as the default "C" locale. If you use en_GB you will get the same
behaviour as for en_US.

--
Peter Eisentraut peter_e(at)gmx(dot)net http://yi.org/peter-e/