Lighthouse has a new layout. Prefer the old one? Return to the old layout, and switch back any time from the link at the top of each page.

This project is archived and is in readonly mode.

Integer range upper bound coerced to exclusive

#222

Submitted by: Brian Findlay

'[1,10]' coerced to '[1,11)'

See tests at https://gist.github.com/bfin/a6e0cce630f38d85c090

Reported by Psycopg website · July 11th, 2014 @ 02:19 AM

State: invalid
Milestone: none
Assigned to: nobody

Activity

  1. Daniele Varrazzo
    Daniele Varrazzo
    • State changed from new to invalid

    You are observing PostgreSQL's behaviours, not psycopg.

    piro=> select '[1,10]'::int4range;
     int4range 
    -----------
     [1,11)
    (1 row)
    

    Check the docs about the canonicalization of builtin discrete ranges.

    July 11th, 2014 @ 09:45 AM