The following bug has been logged online:
Bug reference: 4821
Logged by: Andrew Gierth
Email address: andrew(at)tao11(dot)riddles(dot)org(dot)uk
PostgreSQL version: 8.3-8.4
Operating system: all
Description: LIKE '%_' fails
Details:
# select 'foo' like '%_';
?column?
----------
f
(1 row)
correct result would be 't'
8.1 and 8.2 seem to get this one right.