Re: [HACKERS] Postgres 6.5 beta2 and beta3 problem

Hannu Krosing <hannu(at)trust(dot)ee> writes:
>in single-byte locales it should be easy:

If you do it right, in double-byte locales as well.

>1. sort a char[256] array from 0-255 using the current locale settings,
> do it once, either at startup or when first needed.

Or, alternatively, maintain per-locale table files and mmap them.

>2. use binary search on that array to locate the last char before %
> in this sorted array:

Or, alternatively, maintain another table that maps char values to
lexicographic order (and a per-locale constant for maximum character
order value):

> if (it is not the last char in sorted array)
> then (replace that char with the one at index+1)
> else (
> if (it is not the first char in like string)
> then (discard the last char and goto 2.
> else (don't do the end restriction)
> )

if ( (nextindex = charorder[c]+1) <= maxchar ) {
nextchar = charmap[nextindex];
} else {
no nextchar, append charmap[maxchar] to LIKE base string
}

I don't see where the pain is, but I may be missing something.

-Michael Robinson