From: jrekins@gmail.com
To: pgsql-docs@postgresql.org
Subject: Request for clarification - 8.17.5. Range Input/Output
Date: Thu, 10 Aug 2017 21:28:54 +0000
Message-ID: <20170810212854.3691.10409@wrigleys.postgresql.org> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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.
--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: jrekins@gmail.com
Subject: Re: Request for clarification - 8.17.5. Range Input/Output
In-Reply-To: <20170810212854.3691.10409@wrigleys.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox