FAQ
The following bug has been logged online:

Bug reference: 5848
Logged by:
Email address: curt@net2business.com
PostgreSQL version: 8.1.22
Operating system: Centos 5.5
Description: Between operator issue
Details:

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

Search Discussions

  • Bruce Momjian at Jan 25, 2011 at 9:26 pm

    curt@net2business.com wrote:

    The following bug has been logged online:

    Bug reference: 5848
    Logged by:
    Email address: curt@net2business.com
    PostgreSQL version: 8.1.22
    Operating system: Centos 5.5
    Description: Between operator issue
    Details:

    Statement 'A between B and C' always false if B is greater than C, even if A
    falls between them.
    I think you want BETWEEN SYMMETRIC:

    <literal>BETWEEN SYMMETRIC</> is the same as <literal>BETWEEN</>
    except there is no requirement that the argument to the left of
    <literal>AND</> be less than or equal to the argument on the right.
    If it is not, those two arguments are automatically swapped, so that
    a nonempty range is always implied.

    --
    Bruce Momjian <bruce@momjian.us> http://momjian.us
    EnterpriseDB http://enterprisedb.com

    + It's impossible for everything to be true. +
  • Kevin Grittner at Jan 25, 2011 at 9:27 pm

    "" 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

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-bugs @
categoriespostgresql
postedJan 25, '11 at 8:47p
activeJan 25, '11 at 9:27p
posts3
users3
websitepostgresql.org
irc#postgresql

People

Translate

site design / logo © 2022 Grokbase