Re: Range partitioning and overlap

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Edson Richter <edsonrichter(at)hotmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Range partitioning and overlap
Date: 2020-11-15 04:53:28
Message-ID: CAKFQuwbndKUsbZ=kAHhAgkbgZoMC8stcY648-ntAWqcpUtdgtg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-general

On Fri, Nov 13, 2020 at 2:08 PM Edson Richter <edsonrichter(at)hotmail(dot)com>
wrote:

> *De:* Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> *Enviado:* sexta-feira, 13 de novembro de 2020 17:58
> *Para:* Edson Richter <edsonrichter(at)hotmail(dot)com>
> *Cc:* David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>; pgsql-general <
> pgsql-general(at)postgresql(dot)org>
> *Assunto:* Re: Range partitioning and overlap
>
> Edson Richter <edsonrichter(at)hotmail(dot)com> writes:
> > 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."
>
> > I'm pretty sure I cannot find this statement in PostgreSQL 13
> documentation page about partitioning. May be this statement is in another
> page?
>
> It's in the CREATE TABLE reference page. Seems like it would be a good
> idea to have it also in ddl.sgml's discussion of partitioning, though.
>
>
Patch thread with commit:

https://www.postgresql.org/message-id/DM6PR13MB3988736CF8F5DC5720440231CFE60@DM6PR13MB3988.namprd13.prod.outlook.com

David J.

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Post Gresql 2020-11-15 06:05:20 Re: create table with a CTE
Previous Message David G. Johnston 2020-11-15 03:55:55 Re: create table with a CTE

Browse pgsql-general by date

  From Date Subject
Next Message Morris de Oryx 2020-11-15 06:58:40 ERROR: could not find tuple for statistics object - is there a way to clean this up?
Previous Message David G. Johnston 2020-11-15 04:47:12 Re: Restoring database from false update