BUG #8367: wrong example in 8.17.10

koizumistr@minos.ocn.ne.jp writes:

In 8.17.10 "Constraints on Ranges" of PostgreSQL 9.2.4 Documentation, a
constraint will prevent the overlapping values in an example.
But in the example, range [2010-01-01 11:30, 2010-01-01 13:00) and range
[2010-01-01 14:45, 2010-01-01 15:45) do not overlap.

No, but the second one overlaps with the range value shown in 8.17.2.
So this is correct if it's understood as a continuation of that example.
Still, it's kind of a long way from 8.17.2 to 8.17.10. It might be better
if this section were recast to use a standalone example --- Jeff, what do
you think?

regards, tom lane

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

On Tue, 2013-08-06 at 12:27 -0400, Tom Lane wrote:

koizumistr@minos.ocn.ne.jp writes:

In 8.17.10 "Constraints on Ranges" of PostgreSQL 9.2.4 Documentation, a
constraint will prevent the overlapping values in an example.
But in the example, range [2010-01-01 11:30, 2010-01-01 13:00) and range
[2010-01-01 14:45, 2010-01-01 15:45) do not overlap.

No, but the second one overlaps with the range value shown in 8.17.2.
So this is correct if it's understood as a continuation of that example.
Still, it's kind of a long way from 8.17.2 to 8.17.10. It might be better
if this section were recast to use a standalone example --- Jeff, what do
you think?

That sounds reasonable, patch attached. Minor change, so if nobody has
any more suggestions I'll commit it tomorrow night.

Regards,
Jeff Davis