Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1edYIQ-0001dI-Md for pgsql-docs@arkaria.postgresql.org; Mon, 22 Jan 2018 09:21:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1edYIQ-00079q-5i for pgsql-docs@arkaria.postgresql.org; Mon, 22 Jan 2018 09:21:42 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1ed1no-0003Qt-Ni for pgsql-docs@lists.postgresql.org; Sat, 20 Jan 2018 22:39:56 +0000 Received: from mail-it0-x244.google.com ([2607:f8b0:4001:c0b::244]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ed1nk-0003sY-BY for pgsql-docs@lists.postgresql.org; Sat, 20 Jan 2018 22:39:56 +0000 Received: by mail-it0-x244.google.com with SMTP id w14so5952690itc.3 for ; Sat, 20 Jan 2018 14:39:51 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=urhXIT3QcJLR97X1DbP4HClun8NxXa1qX95rASFLwZs=; b=aAhvt457stomxdIEzRJBuukSSqVqvTTruFwFO7ztjeUR3XPDivNpIjP3RG3fbCsxf+ EgkYvjd//7UXNnk7xHSjbj8bAWNlQp59kEbhUSx+UKJwlDio41k7x4eVcU2OlsyZxoCO /lMjHgVbecM0KTYEVDyXEzJ6SJkCK5dk+ExDUQtt+/ctuiAqOECzTpF7jV6b6QqM62iq CsN9bkywSMNI1KS+8m6O0U6LQ8ea07b7g7JCSV7KvCqXK/sVn+eoC+OytGqenUY2OoK0 PednhCCfFVOc4Y1/UfBSi50IorxCac4zMoOOzIUkW94gHQyoayTTy3y9x1XcWDeRWOtR rglg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=urhXIT3QcJLR97X1DbP4HClun8NxXa1qX95rASFLwZs=; b=N839kFM2QeqTVpdBIdrkVJYGhaar34dBBi5ZyZivEax9U8uERALKn5MSCwYTSBadBy UgmbZkCvHztGIyexljrEw5WnUkOENWckpWozfPekfDMfTunaEcIfm9ioAEmW6M+7jJSd pL0T2c9k43I70TYidKKxd5X4hTzzg/C0bUzzlYdeybKFalBzn+8tZE+CAwUsHWWTZdMm h9xKMCNjOmH9XC+aPDL8FCsIdIvr0wqego451xVW9lsQDeOz2GM82tk+GK/5mwmUmWhZ uwPUtjXM+9ud9olWDqWuqgDWkmedvWaaxAYfkXonT7SCQbCQmnkwLYkkv3Cs+74cikxi WyWg== X-Gm-Message-State: AKwxyteAZK8ViNq2kX2e0UofDcQnqGvFDtdKcZ8cdtqVWti+/D2e0tU0 i3UMLFeyz0JPKjyLMjxGY1bEHdkk2JEpCYpqVeE= X-Google-Smtp-Source: AH8x227a2TsOC/yfX1AJOnHXANz4ddkOc79bLGqw81o6PP+NqlmtLTeGjHHGcloNC/Ul2LwA5NwwbOyTQJF8LsqDNgg= X-Received: by 10.36.10.81 with SMTP id 78mr3163344itw.117.1516487990167; Sat, 20 Jan 2018 14:39:50 -0800 (PST) MIME-Version: 1.0 Received: by 10.2.77.75 with HTTP; Sat, 20 Jan 2018 14:39:48 -0800 (PST) Received: by 10.2.77.75 with HTTP; Sat, 20 Jan 2018 14:39:48 -0800 (PST) In-Reply-To: References: <20180120205832.3624.66654@wrigleys.postgresql.org> From: Nick Farrell Date: Sun, 21 Jan 2018 09:39:48 +1100 Message-ID: Subject: Re: overlapping ranges To: Peter Eisentraut Cc: pgsql-docs@lists.postgresql.org, PG Doc comments form Content-Type: multipart/alternative; boundary="001a113fc130f5ce7005633cdf28" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --001a113fc130f5ce7005633cdf28 Content-Type: text/plain; charset="UTF-8" Further down the page, that is contradicted, where there are numeric ranges spaced every hundred, where it says that is disallowed because of the ambiguity at the overlap point. Either way, the documentation is inconsistent. On 21 Jan. 2018 9:26 am, "Peter Eisentraut" < peter.eisentraut@2ndquadrant.com> wrote: > On 1/20/18 15:58, PG Doc comments form wrote: > > The following documentation comment has been logged on the website: > > > > Page: https://www.postgresql.org/docs/10/static/ddl-partitioning.html > > Description: > > > > In the date partitioning example the first and last dates are the first > of > > the month, which will cause conflicts. The last date needs to be the > final > > day of the same month. > > I don't think so, because the upper bound of the range is not included > in the range. > > -- > Peter Eisentraut http://www.2ndQuadrant.com/ > PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services > --001a113fc130f5ce7005633cdf28 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Further down the page, that is contradicted, where there = are numeric ranges spaced every hundred, where it says that is disallowed b= ecause of the ambiguity at the overlap point. Either way, the documentation= is inconsistent.

On 21 Jan. 2018 9:26 am, "Peter Eisentraut" <peter.eisentraut@2ndquadrant.com> wrote:
On 1/2= 0/18 15:58, PG Doc comments form wrote:
> The following documentation comment has been logged on the website: >
> Page: https://www.postgresql.org= /docs/10/static/ddl-partitioning.html
> Description:
>
> In the date partitioning example the first and last dates are the firs= t of
> the month, which will cause conflicts. The last date needs to be the f= inal
> day of the same month.

I don't think so, because the upper bound of the range is not included<= br> in the range.

--
Peter Eisentraut=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 http://w= ww.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
--001a113fc130f5ce7005633cdf28--