Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rcVwx-000W4O-Nd for pgsql-committers@arkaria.postgresql.org; Tue, 20 Feb 2024 19:38:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rcVww-001JMQ-Bx for pgsql-committers@arkaria.postgresql.org; Tue, 20 Feb 2024 19:38:42 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rcVtx-001HiE-JS for pgsql-committers@lists.postgresql.org; Tue, 20 Feb 2024 19:35:38 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rcVts-0003LW-95 for pgsql-committers@lists.postgresql.org; Tue, 20 Feb 2024 19:35:37 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rcVtp-0007By-HP for pgsql-committers@lists.postgresql.org; Tue, 20 Feb 2024 19:35:30 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rcVto-0003zG-3E for pgsql-committers@lists.postgresql.org; Tue, 20 Feb 2024 19:35:29 +0000 Content-Type: multipart/mixed; boundary="===============3968482319760989519==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Doc: improve explanation of type interval, especially extract(). X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Tue, 20 Feb 2024 19:35:29 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============3968482319760989519== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 RG9jOiBpbXByb3ZlIGV4cGxhbmF0aW9uIG9mIHR5cGUgaW50ZXJ2YWwsIGVzcGVjaWFsbHkgZXh0 cmFjdCgpLgoKVGhlIGV4cGxhbmF0aW9uIG9mIGludGVydmFsJ3MgYmVoYXZpb3IgaW4gZGF0YXR5 cGUuc2dtbCB3YXNuJ3Qgd3JvbmcKZXhhY3RseSwgYnV0IGl0IHdhcyB1bmNsZWFyLCBwYXJ0bHkg YmVjYXVzZSBpdCBidXJpZWQgdGhlIGxlZGUgYWJvdXQKdGhlcmUgYmVpbmcgdGhyZWUgaW50ZXJu YWwgZmllbGRzLiAgUmVhcnJhbmdlIGFuZCB3b3Jkc21pdGggZm9yIG1vcmUKY2xhcml0eS4KClRo ZSBkaXNjdXNzaW9uIG9mIGV4dHJhY3QoKSBjbGFpbWVkIHRoYXQgaW5wdXQgb2YgdHlwZSBkYXRl IHdhcwpoYW5kbGVkIGJ5IGNhc3RpbmcsIGJ1dCBhY3R1YWxseSB0aGVyZSdzIGJlZW4gYSBzZXBh cmF0ZSBTUUwgZnVuY3Rpb24KdGFraW5nIGRhdGUgZm9yIGEgdmVyeSBsb25nIHRpbWUuICBBbHNv LCBpdCB3YXMgbW9zdGx5IHNpbGVudCBhYm91dApob3cgaW50ZXJ2YWwgaW5wdXRzIGFyZSBoYW5k bGVkLCBidXQgdGhlcmUgYXJlIHNldmVyYWwgZmllbGQgdHlwZXMKZm9yIHdoaWNoIGl0IHNlZW1z IHVzZWZ1bCB0byBiZSBzcGVjaWZpYy4KCkltcHJvdmUgZGlzY3Vzc2lvbiBvZiBqdXN0aWZ5X2Rh eXMoKS9qdXN0aWZ5X2hvdXJzKCkgdG9vLgoKSW4gcGFzc2luZywgcmVtb3ZlIHZlcnRpY2FsIHNw YWNlIGluIHNvbWUgZ3JvdXBzIG9mIGV4YW1wbGVzLAphcyB0aGVyZSB3YXMgbGl0dGxlIGNvbnNp c3RlbmN5IGFib3V0IHdoZXRoZXIgdG8gaGF2ZSBzdWNoIHNwYWNlCm9yIG5vdC4gIChJIG9ubHkg ZGlkIHRoaXMgd2l0aGluIHRoZSBkYXRldGltZSBmdW5jdGlvbnMgc2VjdGlvbjsKdGhlcmUgYXJl IHNvbWUgcmVsYXRlZCBpbmNvbnNpc3RlbmNpZXMgZWxzZXdoZXJlLikKClBlciBkaXNjdXNzaW9u IG9mIGJ1ZyAjMTgzNDggZnJvbSBNaWNoYWVsIEJvbmRhcmVua28uICBUaGVyZQptYXkgYmUgc29t ZSBjb2RlIGNoYW5nZXMgY29taW5nIG91dCBvZiB0aGF0IGRpc2N1c3Npb24gdG9vLApidXQgd2Ug bGlrZWx5IHdvbid0IGJhY2stcGF0Y2ggdGhlbS4gIFRoaXMgZG9jcy1vbmx5IHBhdGNoCnNlZW1z IHVzZWZ1bCB0byBiYWNrLXBhdGNoLCB0aG91Z2ggSSBvbmx5IGNhcnJpZWQgaXQgYmFjayB0bwp2 MTMgYmVjYXVzZSBpdCBkaWRuJ3QgYXBwbHkgZWFzaWx5IGluIHYxMi4KCkRpc2N1c3Npb246IGh0 dHBzOi8vcG9zdGdyLmVzL20vMTgzNDgtYjA5N2EzNTg3ZGZkZThhNEBwb3N0Z3Jlc3FsLm9yZwoK QnJhbmNoCi0tLS0tLQpSRUxfMTRfU1RBQkxFCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQu cG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi9lYmY1MmU5Yjc1MzI1MGEwYmUwNzM3NWM4YzVm MjkwZTg3ZWRlZjJmCgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpkb2Mvc3JjL3NnbWwv ZGF0YXR5cGUuc2dtbCB8ICA3MSArKysrKysrKysrKysrKysrLS0tLS0tLS0tLS0tLQpkb2Mvc3Jj L3NnbWwvZnVuYy5zZ21sICAgICB8IDEwOSArKysrKysrKysrKysrKysrKysrKysrKy0tLS0tLS0t LS0tLS0tLS0tLS0tLS0KMiBmaWxlcyBjaGFuZ2VkLCA5NiBpbnNlcnRpb25zKCspLCA4NCBkZWxl dGlvbnMoLSkKCg== --===============3968482319760989519==--