BUG #5478: ILIKE operator returns wrong result - Mailing list pgsql-bugs

The following bug has been logged online:

Bug reference:      5478
Logged by:          Markus
Email address:      markus.herven@outpost24.com
PostgreSQL version: PostgreSQL 8.4.
Operating system:   Ubuntu 10.04
Description:        ILIKE operator returns wrong result
Details:

The following query

select 'ba' ilike '%__%';

return true as expected in 8.2 but false in 8.4.