public inbox for [email protected]
help / color / mirror / Atom feedFrom: Pantelis Theodosiou <[email protected]>
To: Nick Farrell <[email protected]>
Cc: Peter Eisentraut <[email protected]>
Cc: [email protected]
Cc: PG Doc comments form <[email protected]>
Subject: Re: overlapping ranges
Date: Mon, 22 Jan 2018 09:31:48 +0000
Message-ID: <CAE3TBxwXRoko_OD-SSkXSPLPO0RsA_1TP6pXv-Xc0t5BoLzAzw@mail.gmail.com> (raw)
In-Reply-To: <CANGxkfC16MSumQ5Fhe+y9B36YzHDdUB3OU8DArtJ5Oc2a2mq6A@mail.gmail.com>
References: <[email protected]>
<[email protected]>
<CANGxkfC16MSumQ5Fhe+y9B36YzHDdUB3OU8DArtJ5Oc2a2mq6A@mail.gmail.com>
The CREATE TABLE page has this explanation, about FROM and TO in
partitioning declarations:
> When creating a range partition, the lower bound specified with FROM is
an inclusive bound, whereas the upper bound specified with TO is an
exclusive bound. That is, the values specified in the FROM list are valid
values of the corresponding partition key columns for this partition,
whereas those in the TO list are not.
On Sat, Jan 20, 2018 at 10:39 PM, Nick Farrell <[email protected]>
wrote:
> 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
>>
>
view thread (5+ messages) latest in thread
reply
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: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected], [email protected]
Subject: Re: overlapping ranges
In-Reply-To: <CAE3TBxwXRoko_OD-SSkXSPLPO0RsA_1TP6pXv-Xc0t5BoLzAzw@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox