De: David G. Johnston <david.g.johns...@gmail.com>
Enviado: sexta-feira, 13 de novembro de 2020 17:32
Para: Edson Richter <edsonrich...@hotmail.com>
Cc: pgsql-general <pgsql-gene...@postgresql.org>
Assunto: Re: Range partitioning and overlap

On Fri, Nov 13, 2020 at 1:29 PM Edson Richter 
<edsonrich...@hotmail.com<mailto:edsonrich...@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


Reply via email to