Re: BUG #8367: wrong example in 8.17.10

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: koizumistr(at)minos(dot)ocn(dot)ne(dot)jp
Cc: pgsql-bugs(at)postgresql(dot)org, Jeff Davis <pgsql(at)j-davis(dot)com>
Subject: Re: BUG #8367: wrong example in 8.17.10
Date: 2013-08-06 16:27:19
Message-ID: 30472.1375806439@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

koizumistr(at)minos(dot)ocn(dot)ne(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Fabien 2013-08-06 18:51:01 "with recursive" ignores side effects?
Previous Message koizumistr 2013-08-06 16:02:29 BUG #8367: wrong example in 8.17.10