Re: BUG #5848: Between operator issue

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <curt(at)net2business(dot)com>,<pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #5848: Between operator issue
Date: 2011-01-25 21:27:00
Message-ID: 4D3EEBC40200002500039C7F@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"" <curt(at)net2business(dot)com> wrote:

> Statement 'A between B and C' always false if B is greater than C,
> even if A falls between them.

I'm pretty sure that's required by the standard, and doing otherwise
could break code which counts on standard semantics.

-Kevin

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Josh Berkus 2011-01-25 21:41:38 Re: Multicolun index creation never completes on 9.0.1/solaris
Previous Message Bruce Momjian 2011-01-25 21:26:02 Re: BUG #5848: Between operator issue