BUG #4416: Between operator is not working as expected - Mailing list pgsql-bugs

The following bug has been logged online:

Bug reference:      4416
Logged by:          Murali
Email address:      muralidoss@rediffmail.com
PostgreSQL version: 8.2.6
Operating system:   Linux
Description:        Between operator is not working as expected
Details:

Actually sql works fine in solaris with 8.2.5 postgresql version but same
sql query is not working in linux.

fyi...both the database in linux and solaris are having similar structure
and data too.

Here is the query i am try to execute

select * from table1 where col1 between 'SM' and 'SM~';

Please guide me