RE: Range partitioning and overlap - Mailing list pgsql-general

From Edson Richter
Subject RE: Range partitioning and overlap
Date
Msg-id DM6PR13MB3988F15C65F793B32C1E1F30CFE60@DM6PR13MB3988.namprd13.prod.outlook.com
Whole thread Raw
In response to Re: Range partitioning and overlap  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Range partitioning and overlap  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general

De: David G. Johnston <david.g.johnston@gmail.com>
Enviado: sexta-feira, 13 de novembro de 2020 17:32
Para: Edson Richter <edsonrichter@hotmail.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
Assunto: Re: Range partitioning and overlap
 
On Fri, Nov 13, 2020 at 1:29 PM Edson Richter <edsonrichter@hotmail.com> wrote:
"Range Partitioning

The table is partitioned into ranges defined by a key column or set of columns, with no overlap between the ranges of values assigned to different partitions. For example, one might partition by date ranges, or by ranges of identifiers for particular business objects."

Is there a misinterpretation from my side, or examples are inconsistent with the paragraph above?

Further on the documentation: "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."

David J.

I'm pretty sure I cannot find this statement in PostgreSQL 13 documentation page about partitioning. May be this statement is in another page?
Would you mind to share the URL with this statement?

Thanks,

Edson


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: New "function tables" in V13 documentation
Next
From: Adrian Klaver
Date:
Subject: Re: New "function tables" in V13 documentation