Re: [BUGS] BUG: ILIKE with single-byte encoding

2008-02-29 Thread Tom Lane
Rolf Jentsch <[EMAIL PROTECTED]> writes: > With PostgreSQL 8.3.0 the following bug has been introduced with the ILIKE or > ~~* operator: > In a database with single-byte encoding as LATIN1 the expression > SELECT 'aü' ILIKE '%ü'; > returns false. > For the single-byte case there are some places w

[BUGS] BUG: ILIKE with single-byte encoding

2008-02-28 Thread Rolf Jentsch
Hello, With PostgreSQL 8.3.0 the following bug has been introduced with the ILIKE or ~~* operator: In a database with single-byte encoding as LATIN1 the expression SELECT 'aü' ILIKE '%ü'; returns false. This error is true for every pattern, where a % is followed by a char with a decimal value