BUG #4841: like and trim queries

The following bug has been logged online:

Bug reference:      4841
Logged by:          jeewan
Email address:      ccoew.g1@gmail.com
PostgreSQL version: 8.3.6
Operating system:   windows/fedora
Description:        like and trim queries
Details:

1.Queries having some combination of % and _ in like query does not
work.......
example-

like %_%

2.'trim' is not supported by this version on both the platforms

ERROR:  function pg_catalog.rtrim(numeric, integer) does not exist
LINE t: ...ct col2_date,col4_int,colt_timestamp,col5_numeric,trim(trail...
                                                             ^
HINT:  No function matches the given name and argument types.