BUG #4416: Between operator is not working as expected

From: "Murali" <muralidoss(at)rediffmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4416: Between operator is not working as expected
Date: 2008-09-13 23:26:54
Message-ID: 200809132326.m8DNQs8b016044@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 4416
Logged by: Murali
Email address: muralidoss(at)rediffmail(dot)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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Stephan Szabo 2008-09-14 01:41:45 Re: BUG #4416: Between operator is not working as expected
Previous Message Martin Schäfer 2008-09-11 14:23:10 Incorrect cursor behaviour with gist index