Re: Range partitioning and overlap

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Range partitioning and overlap
Дата
Msg-id CAKFQuwavKNFu5oAL4c36uuoWgsMBteSrBBxOg4nrPYoXokHYmw@mail.gmail.com
обсуждение исходный текст
Ответ на Range partitioning and overlap  (Edson Richter <edsonrichter@hotmail.com>)
Ответы RE: Range partitioning and overlap  (Edson Richter <edsonrichter@hotmail.com>)
Список pgsql-general
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.

В списке pgsql-general по дате отправления:

Предыдущее
От: Edson Richter
Дата:
Сообщение: Range partitioning and overlap
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: New "function tables" in V13 documentation