Request for clarification - 8.17.5. Range Input/Output

From: jrekins(at)gmail(dot)com
To: pgsql-docs(at)postgresql(dot)org
Subject: Request for clarification - 8.17.5. Range Input/Output
Date: 2017-08-10 21:28:54
Message-ID: 20170810212854.3691.10409@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/9.6/static/rangetypes.html
Description:

Hi,

I am reading this section of the manual and the results I see are not what I
expect according to the examples, except for the last example showing empty.

Perhaps I have misunderstood the comments, but take the first example:

-- includes 3, does not include 7, and does include all points in between.

I expect the results of the select, from my reading, to show 3,6. However
when I try this I see 3,7:

jredb=> SELECT '[3,7)'::int4range;
+-----------+
| int4range |
+-----------+
| [3,7) |
+-----------+
(1 row)

Similarly the next two examples show different results to my expectations: I
see 4,7 and 4,5.

Can somebody explain if my understanding is wrong, and kindly post the
results they see?

Thanks,
J.

Browse pgsql-docs by date

  From Date Subject
Next Message Peter Eisentraut 2017-08-11 02:56:46 Re: Use of term Master/Slave
Previous Message jrekins 2017-08-10 19:50:44 Dead link for 'DocBook XSL Stylesheets'