Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group