Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kdgIp-0004bU-5F for pgsql-general@arkaria.postgresql.org; Fri, 13 Nov 2020 21:08:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kdgIn-00012q-D9 for pgsql-general@arkaria.postgresql.org; Fri, 13 Nov 2020 21:08:13 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kdgIm-00012j-CG for pgsql-general@lists.postgresql.org; Fri, 13 Nov 2020 21:08:13 +0000 Received: from mail-bn8nam12olkn2107.outbound.protection.outlook.com ([40.92.21.107] helo=NAM12-BN8-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kdgIj-0005JY-Dd for pgsql-general@postgresql.org; Fri, 13 Nov 2020 21:08:10 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=fgY8dBwTYdKmz6D7EI18Gu+LVqwgt8lcP55HZOksLHjQrjL+1b50tBeCTgSgV/W20qV/zM8MDgbK3amLSFFWEBORjB1Lu32eAu5m4r1XxbwPn/dUB+0uw309YICwXMntbkBT80fQWxMVnXxngcV7tG+K33WRFOjDZTyul/2qTef4+xdc1TJa7uH4PGhMVuFgYM2eevmy6oPj5Y4iy+6hIQy11umBkKNE7vvps0Gm7lq+YxFdr2SikInTkOHGKuzy2k3Lqtu3JGmGFyhJ9YDFhQJ0uavICZPMumZdfxtrLBnkLlxezsOAjUKhLlm2kzrocc9Dbu3QaJ4GuHSK4MxkOg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=wifljmrQBl+XY7ZMb4OcVzbIZeclHea/1hZAxD2awDY=; b=CUjBLn6BDJNedK2AXQzBa1ygX3qqZ9WfZmjbVFhG8gasjMTpKPACq/863L3P2MVjg2Wrov0wY8uaDbDty+izXCUMNm8WtAiGWnY1gdusaOp5kvX8dYPpQpgsBFT/YTJQzWWEP5dscL9gLCBLDVu6QSeQn1YVq1WVwjPyLsCwoRx0v1sGmrtvy/WNQoNKq2isRNBqgq0fYCFV4XYAWalXn8lfep6clvirEYIw67czc2wote6k98U5XKJf3O9GuP8PmgQnlhtHRfhcWProYrNnDCDzJxjV+cqgAA1Uuj5EaNwD7s97QT9RyRJ26YuscZJOdnj3RQsLg+tKeeMQewLyVQ== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=none; dmarc=none; dkim=none; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=hotmail.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=wifljmrQBl+XY7ZMb4OcVzbIZeclHea/1hZAxD2awDY=; b=i8VtyHwb08OPfcpjN1wjF8OJmQY2UMvdaTpcI/uYrVsJ9B9UNVAXUZwCWryisHYTTOPLmWfUEWMWEOTN8XP4+dinQF6CdwPNA/KJTKZk4Alcloau8wfolZ7L2PqTLEEMjw7tirebUySjmrGsX1skhWTyYQv02DambAJpGAPoa6fzjHd6M1UDMjkspRDnMYGuw9LCChZk2WNqU4mAAneFh8Y1v7h8fwhsqq32/6bmILcOK5EhdZi1fEmE32ffoiJfHqMZ8Ggff1yZNjTeJX7Bkj9SpTA8uPb/6on6BIlWnOMWF8TcdXfP4BxPjYWWGcY/UOKm1t6j94Z5lglLtzlRsw== Received: from DM6PR13MB3988.namprd13.prod.outlook.com (2603:10b6:5:28e::12) by DM6PR13MB3195.namprd13.prod.outlook.com (2603:10b6:5:19a::12) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.3564.21; Fri, 13 Nov 2020 21:08:06 +0000 Received: from DM6PR13MB3988.namprd13.prod.outlook.com ([fe80::1841:4698:4073:bba5]) by DM6PR13MB3988.namprd13.prod.outlook.com ([fe80::1841:4698:4073:bba5%8]) with mapi id 15.20.3564.025; Fri, 13 Nov 2020 21:08:06 +0000 From: Edson Richter To: Tom Lane CC: "David G. Johnston" , pgsql-general Subject: RE: Range partitioning and overlap Thread-Topic: Range partitioning and overlap Thread-Index: AQHWufq6zsMyFiX8HU2Sv5MoEfI9+anGhFsAgAADaPiAAAOjAIAAAqL/ Date: Fri, 13 Nov 2020 21:08:06 +0000 Message-ID: References: , ,<398613.1605301084@sss.pgh.pa.us> In-Reply-To: <398613.1605301084@sss.pgh.pa.us> Accept-Language: pt-BR, en-US Content-Language: pt-BR X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-messagesentrepresentingtype: 1 x-tmn: [dXwoHHltGHLuCV0DmoUrN+p9U6Lsxnp6PFxzFVwvlTQBHxx0AQO3bfF0dgFjb4wp] x-ms-publictraffictype: Email x-ms-office365-filtering-correlation-id: d3c1374e-0bb3-480c-3921-08d88818378b x-ms-traffictypediagnostic: DM6PR13MB3195: x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: Qo9II4BYrUgNVOPyrKQstccWra3HjIrRR7eKDDdAjExSow3cSNsnb0ueFXgKPSrXoVrhAth1Xc2qFdgJv1vtwGp4to6kHvLd/UZlDd+0ozRdceRfnx3BgyZCnlnrnJvyB520iMxUa4CSm7Iy1V/efaxTa2m/W5RfSC+57g30YCd4Mb4ov4/GxUWoJASLOIC4wGOMJVBm5qOtkkoCG7VWIw== x-ms-exchange-antispam-messagedata: TA84NSzTjRys+ZFlIr1UnuGKRMQbyoByjVnVScUqFkpSqJd1yjWNREv6vqHppNuKoAPhoCN5Ko/P5FBzxsOIlws26b0jdoMNc/qqP3ewKoGWao2igY29EnW1m11SFoaueLLjPlK7m+ntMzU+hB8fRB+EDwp69tQIljqo+0HAo5FaG8FFOKyBtHaLAx1GcgDGG4ZT/Nyp3F1zjSDqhTR3aw== x-ms-exchange-transport-forked: True Content-Type: multipart/alternative; boundary="_000_DM6PR13MB3988A66E9D2BCCD499B550ABCFE60DM6PR13MB3988namp_" MIME-Version: 1.0 X-OriginatorOrg: sct-15-20-3174-8-msonline-outlook-32ef5.templateTenant X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: DM6PR13MB3988.namprd13.prod.outlook.com X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-CrossTenant-Network-Message-Id: d3c1374e-0bb3-480c-3921-08d88818378b X-MS-Exchange-CrossTenant-originalarrivaltime: 13 Nov 2020 21:08:06.4532 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-Transport-CrossTenantHeadersStamped: DM6PR13MB3195 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --_000_DM6PR13MB3988A66E9D2BCCD499B550ABCFE60DM6PR13MB3988namp_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable De: Tom Lane Enviado: sexta-feira, 13 de novembro de 2020 17:58 Para: Edson Richter Cc: David G. Johnston ; pgsql-general Assunto: Re: Range partitioning and overlap Edson Richter writes: > Further on the documentation: "When creating a range partition, the lower= bound specified with FROM is an inclusive bound, whereas the upper bound s= pecified with TO is an exclusive bound." > I'm pretty sure I cannot find this statement in PostgreSQL 13 documentati= on 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. regards, tom lane Thanks! Regards, Edson --_000_DM6PR13MB3988A66E9D2BCCD499B550ABCFE60DM6PR13MB3988namp_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
De:<= /b> Tom = Lane <tgl@sss.pgh.pa.us>
Enviado: sexta-feira, 13 = de novembro de 2020 17:58
Para: Edson Richter <edsonrichter@hotmail.com>
Cc: David G. Johnston <david.g.johnston@gmail.com>; pgsql-gene= ral <pgsql-general@postgresql.org>
Assunto: Re: Range partitioning and overlap
 
Edson Richter <edsonrichter@hotmail.com> wri= tes:
> Further on the documentation: "When creating a range partition, t= he 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 document= ation 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 goo= d
idea to have it also in ddl.sgml's discussion of partitioning, though.

        &n= bsp;            = ;   regards, tom lane

Thanks!

Regards,

Edson

--_000_DM6PR13MB3988A66E9D2BCCD499B550ABCFE60DM6PR13MB3988namp_--