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 1rcVtx-000VmV-2r for pgsql-committers@arkaria.postgresql.org; Tue, 20 Feb 2024 19:35:37 +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 1rcVtv-001HIs-CW for pgsql-committers@arkaria.postgresql.org; Tue, 20 Feb 2024 19:35:35 +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 1rcVtv-001HIk-5N for pgsql-committers@lists.postgresql.org; Tue, 20 Feb 2024 19:35:35 +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-0003LV-8r for pgsql-committers@lists.postgresql.org; Tue, 20 Feb 2024 19:35:35 +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-0007Bz-HT 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-0003zK-3p for pgsql-committers@lists.postgresql.org; Tue, 20 Feb 2024 19:35:29 +0000 Content-Type: multipart/mixed; boundary="===============4603284892385893252==" 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 --===============4603284892385893252== 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 QnJhbmNoCi0tLS0tLQpSRUxfMTNfU1RBQkxFCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQu cG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi9lYjFkMDA4YTdhMThmMmNmODYzZTIxZTI4NWI2 ZGI1ODU4ZDBkNWQ5CgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpkb2Mvc3JjL3NnbWwv ZGF0YXR5cGUuc2dtbCB8ICA3MSArKysrKysrKysrKysrKysrLS0tLS0tLS0tLS0tLQpkb2Mvc3Jj L3NnbWwvZnVuYy5zZ21sICAgICB8IDEwOCArKysrKysrKysrKysrKysrKysrKysrKy0tLS0tLS0t LS0tLS0tLS0tLS0tLS0KMiBmaWxlcyBjaGFuZ2VkLCA5NiBpbnNlcnRpb25zKCspLCA4MyBkZWxl dGlvbnMoLSkKCg== --===============4603284892385893252==--