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 1uawvH-00BrCE-Oj for pgsql-docs@arkaria.postgresql.org; Sun, 13 Jul 2025 13:39:19 +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 1uawvF-00FswJ-6x for pgsql-docs@arkaria.postgresql.org; Sun, 13 Jul 2025 13:39:17 +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 1uawvE-00FswB-Tz for pgsql-docs@lists.postgresql.org; Sun, 13 Jul 2025 13:39:17 +0000 Received: from forward500d.mail.yandex.net ([178.154.239.208]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uawvD-007LdG-02 for pgsql-docs@lists.postgresql.org; Sun, 13 Jul 2025 13:39:17 +0000 Received: from mail-nwsmtp-mxback-production-main-42.klg.yp-c.yandex.net (mail-nwsmtp-mxback-production-main-42.klg.yp-c.yandex.net [IPv6:2a02:6b8:c42:da4d:0:640:4e4c:0]) by forward500d.mail.yandex.net (Yandex) with ESMTPS id 8FE27616C1; Sun, 13 Jul 2025 16:39:13 +0300 (MSK) Received: from mail.yandex.ru (2a02:6b8:c42:86c7:0:640:e66d:0 [2a02:6b8:c42:86c7:0:640:e66d:0]) by mail-nwsmtp-mxback-production-main-42.klg.yp-c.yandex.net (mxback/Yandex) with HTTPS id ccJbnvAMKSw0-kzY83Rs1; Sun, 13 Jul 2025 16:39:12 +0300 X-Yandex-Fwd: 1 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yandex.ru; s=mail; t=1752413952; bh=4u9uCb1UAWk2kT0RAKq1ZvzaxSfMeeSq+DEUM71+fyI=; h=Message-Id:References:Date:Subject:To:In-Reply-To:From; b=dlXIa+6RWh50CPBVQBFneieSAA1FGCyfAhKuQZdfWjpcgboew3xDaUhwuf9X5HS/C H/xcs+wSr7hVifAs1xjPiA/5IRS44ra/qlebnHME/ve81lMXcw5F+FdGdeoFbXKrIc njZjDPI7vHLW9cbbTh+CbJdvY9QmqePRERe5gn0I= Authentication-Results: mail-nwsmtp-mxback-production-main-42.klg.yp-c.yandex.net; dkim=pass header.i=@yandex.ru Received: by mail-sendbernar-production-main-67.klg.yp-c.yandex.net (sendbernar/Yandex) with HTTPS id 9d821de1b8fe9c10c9b129a122564474; Sun, 13 Jul 2025 16:39:12 +0300 From: KES To: David G. Johnston , "pgsql-docs@lists.postgresql.org" In-Reply-To: <47411752413203@mail.yandex.ru> References: <175175762761.3157502.18041595164515835428@wrigleys.postgresql.org> <47411752413203@mail.yandex.ru> Subject: Re: Unexpected behaviour: it was documented to return the same value MIME-Version: 1.0 X-Mailer: Yamail [ http://yandex.ru ] 5.0 Date: Sun, 13 Jul 2025 16:39:12 +0300 Message-Id: <25341752413730@mail.yandex.ru> Content-Transfer-Encoding: base64 Content-Type: text/html; charset=utf-8 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk PGRpdj5JIHN1cHBvc2UgdGhhdCBERUZBVUxUIHN5bnRheCBzaG91bGQgYmUgdXNlZCB0byBzZXQg c2V0dGluZyB0byBpdHMgZGVmYXVsdCB2YWx1ZS4gRWcuPC9kaXY+PGRpdj48ZGl2PnNldF9jb25m aWcoICdteS5vcHRpb24nLCBERUZBVUxULCBmYWxzZSApPC9kaXY+PGRpdj5UaGlzIGlzIGNsZWFy IHdoYXQgc2hvdWxkIGhhcHBlbiBoZXJlLiBBbHNvIHRoaXMgc3ludGF4IHdpbGwgY29ycmVzcG9u ZCB0byBvdGhlciBwbGFjZXMsIGVnLiBJTlNFUlQgSU5UTyB4eCAobmFtZSkgVkFMVUVTIChERUZB VUxUKS48L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj5Vc2luZyBOVUxMIHRvIHNldCByZXNldCB0aGUg dmFsdWUgdG8gdGhlIGRlZmF1bHQgaXMgdmVyeSB2ZXJ5IGNvbmZ1c2luZy48L2Rpdj48ZGl2Pjxk aXY+c2V0X2NvbmZpZyggJ215Lm9wdGlvbicsIE5VTEwsIGZhbHNlICk8L2Rpdj48ZGl2PkV4cGVj dGVkOiB0aGlzIGNhbGwgc2hvdWxkIG1ha2Ugb3B0aW9uIHVucmVjb2duaXphYmxlIGFnYWluLjwv ZGl2PjwvZGl2PjwvZGl2PjxkaXY+PGJyIC8+PC9kaXY+PGRpdj48YnIgLz48L2Rpdj48ZGl2Pi0t LS0tLS0tLS0tLS0tLS08L2Rpdj4KICAgICAgICAgICAgICAgICAgICAgICAgPGRpdj7QmtC+0LzR gzogRGF2aWQgRy4gSm9obnN0b24gKGRhdmlkLmcuam9obnN0b25AZ21haWwuY29tKSwgcGdzcWwt ZG9jc0BsaXN0cy5wb3N0Z3Jlc3FsLm9yZyAocGdzcWwtZG9jc0BsaXN0cy5wb3N0Z3Jlc3FsLm9y Zyk7PGJyIC8+PC9kaXY+CiAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAg ICAgICAgICA8ZGl2PtCi0LXQvNCwOiBVbmV4cGVjdGVkIGJlaGF2aW91cjogaXQgd2FzIGRvY3Vt ZW50ZWQgdG8gcmV0dXJuIHRoZSBzYW1lIHZhbHVlOzxiciAvPjwvZGl2PgogICAgICAgICAgICAg ICAgICAgICAgICA8ZGl2PjEzLjA3LjIwMjUsIDE2OjM0LCAiS0VTIiAmbHQ7a2VzLWtlc0B5YW5k ZXgucnUmZ3Q7OjxiciAvPjwvZGl2PgogICAgICAgICAgICAgICAgICAgICAgICA8YmxvY2txdW90 ZT48ZGl2Pkkgd291bGQgcHJlZmVyIHRvIHJlbW92ZSB0aGUgb3B0aW9uIGZyb20gdGhlIGNvbmZp Z3VyYXRpb24gbGlzdCBpbnN0ZWFkIG9mIGhhdmluZyBpdCByZXNldCB0byBlbXB0eSBzdHJpbmcu PC9kaXY+PGRpdj7CoDwvZGl2PjxkaXY+RWcuIHNldF9jb25maWcoICdteS5vcHRpb24nLCBOVUxM LCBmYWxzZSApPC9kaXY+PGRpdj7CoDwvZGl2PjxkaXY+SGF2aW5nIGl0IHRvIHJldHVybiB0aGUg ZW1wdHkgc3RyaW5nIGNhdXNlIGRpZmZlcmVuY2VzIGluIHRoZSBiZWhhdmlvdXIgd2hlbiBwYXJh bWV0ZXIgaXMgbm90IHJlY29nbml6ZWQgYXQgYWxsIGFuZCB3aGVuIGl0IHNldHVwIHRvIGRlZmF1 bHQuPC9kaXY+PGRpdj7CoDwvZGl2PjxkaXY+SG93IHRvIG1ha2UgaXQgInVucmVjb2duaXphYmxl IiBhZ2FpbiB1c2luZyBzZXRfY29uZmlnL1JFU0VUPzwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PlRo ZSBleGFjdCBwcm9ibGVtIEkgYW0gdHJ5aW5nIHRvIHJlc29sdmUgd2FzIGFza2VkIGhlcmU6IDxh IGhyZWY9Imh0dHBzOi8vc3RhY2tvdmVyZmxvdy5jb20vcS81MDkyMzkxMS80NjMyMDE5Ij5odHRw czovL3N0YWNrb3ZlcmZsb3cuY29tL3EvNTA5MjM5MTEvNDYzMjAxOTwvYT48L2Rpdj48ZGl2PsKg PC9kaXY+PGRpdj48YnIgLz48L2Rpdj48ZGl2PjxiciAvPjwvZGl2PjxkaXY+LS0tLS0tLS0tLS0t LS0tLTwvZGl2PgogICAgICAgICAgICAgICAgICAgICAgICA8ZGl2PtCa0L7QvNGDOiA8YSBocmVm PSJtYWlsdG86a2VzLWtlc0B5YW5kZXgucnUiPmtlcy1rZXNAeWFuZGV4LnJ1PC9hPiAoPGEgaHJl Zj0ibWFpbHRvOmtlcy1rZXNAeWFuZGV4LnJ1Ij5rZXMta2VzQHlhbmRleC5ydTwvYT4pLCA8YSBo cmVmPSJtYWlsdG86cGdzcWwtZG9jc0BsaXN0cy5wb3N0Z3Jlc3FsLm9yZyI+cGdzcWwtZG9jc0Bs aXN0cy5wb3N0Z3Jlc3FsLm9yZzwvYT4gKDxhIGhyZWY9Im1haWx0bzpwZ3NxbC1kb2NzQGxpc3Rz LnBvc3RncmVzcWwub3JnIj5wZ3NxbC1kb2NzQGxpc3RzLnBvc3RncmVzcWwub3JnPC9hPik7PGJy IC8+PC9kaXY+CiAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAg ICA8ZGl2PtCi0LXQvNCwOiBVbmV4cGVjdGVkIGJlaGF2aW91cjogaXQgd2FzIGRvY3VtZW50ZWQg dG8gcmV0dXJuIHRoZSBzYW1lIHZhbHVlOzxiciAvPjwvZGl2PgogICAgICAgICAgICAgICAgICAg ICAgICA8ZGl2PjA3LjA3LjIwMjUsIDE3OjQwLCAiRGF2aWQgRy4gSm9obnN0b24iICZsdDs8YSBo cmVmPSJtYWlsdG86ZGF2aWQuZy5qb2huc3RvbkBnbWFpbC5jb20iPmRhdmlkLmcuam9obnN0b25A Z21haWwuY29tPC9hPiZndDs6PGJyIC8+PC9kaXY+CiAgICAgICAgICAgICAgICAgICAgICAgIDxi bG9ja3F1b3RlPjxkaXYgZGlyPSJsdHIiPjxkaXYgZGlyPSJsdHIiPjxkaXYgY2xhc3M9IjlkMjY2 MmQ0YzAzZTZiOWYzYmI5YTQzMGE0MmY3NGU1ODFiZjhlMzYxY2ViYjJjNmQ2NGZiNGQ2ODQyZDZl YmdtYWlsX2RlZmF1bHQiIHN0eWxlPSJmb250LWZhbWlseTonYXJpYWwnICwgJ2hlbHZldGljYScg LCBzYW5zLXNlcmlmIj48c3BhbiBzdHlsZT0iZm9udC1mYW1pbHk6J2FyaWFsJyAsICdoZWx2ZXRp Y2EnICwgc2Fucy1zZXJpZiI+T24gTW9uLCBKdWwgNywgMjAyNSBhdCA2OjUx4oCvQU0gRGF2aWQg Ry4gSm9obnN0b24gJmx0OzxhIGhyZWY9Im1haWx0bzpkYXZpZC5nLmpvaG5zdG9uQGdtYWlsLmNv bSI+ZGF2aWQuZy5qb2huc3RvbkBnbWFpbC5jb208L2E+Jmd0OyB3cm90ZTo8L3NwYW4+PC9kaXY+ PC9kaXY+PGRpdiBjbGFzcz0iZDk2ZDBmYTAxZDdjY2VlOTgyMTlhOGU5NGJjY2YwNjFmMTNjYTQ4 NzE5YzhhNjAwMzM5MDViMjNiMzk2NzVhZ21haWxfcXVvdGUgNDI1Njg1NDI5YmZlYTk2ZjQxZGMx MTQ5OGI5NzhiYWY1ZWMwNzhlOTIzMzYwMWVhYjRkY2NhY2Q1ODBlNjAyMmdtYWlsX3F1b3RlX2Nv bnRhaW5lciI+PGJsb2NrcXVvdGUgY2xhc3M9ImQ5NmQwZmEwMWQ3Y2NlZTk4MjE5YThlOTRiY2Nm MDYxZjEzY2E0ODcxOWM4YTYwMDMzOTA1YjIzYjM5Njc1YWdtYWlsX3F1b3RlIiBzdHlsZT0iYm9y ZGVyLWxlZnQtY29sb3I6cmdiKCAyMDQgLCAyMDQgLCAyMDQgKTtib3JkZXItbGVmdC1zdHlsZTpz b2xpZDtib3JkZXItbGVmdC13aWR0aDoxcHg7bWFyZ2luOjBweCAwcHggMHB4IDAuOGV4O3BhZGRp bmctbGVmdDoxZXgiPk9uIFNhdHVyZGF5LCBKdWx5IDUsIDIwMjUsIFBHIERvYyBjb21tZW50cyBm b3JtICZsdDs8YSBocmVmPSJtYWlsdG86bm9yZXBseUBwb3N0Z3Jlc3FsLm9yZyIgdGFyZ2V0PSJf YmxhbmsiPm5vcmVwbHlAcG9zdGdyZXNxbC5vcmc8L2E+Jmd0OyB3cm90ZTo8YnIgLz48YmxvY2tx dW90ZSBjbGFzcz0iZDk2ZDBmYTAxZDdjY2VlOTgyMTlhOGU5NGJjY2YwNjFmMTNjYTQ4NzE5Yzhh NjAwMzM5MDViMjNiMzk2NzVhZ21haWxfcXVvdGUiIHN0eWxlPSJib3JkZXItbGVmdC1jb2xvcjpy Z2IoIDIwNCAsIDIwNCAsIDIwNCApO2JvcmRlci1sZWZ0LXN0eWxlOnNvbGlkO2JvcmRlci1sZWZ0 LXdpZHRoOjFweDttYXJnaW46MHB4IDBweCAwcHggMC44ZXg7cGFkZGluZy1sZWZ0OjFleCI+VGhl IGZvbGxvd2luZyBkb2N1bWVudGF0aW9uIGNvbW1lbnQgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3 ZWJzaXRlOjxiciAvPgo8YnIgLz4KUGFnZTogPGEgaHJlZj0iaHR0cHM6Ly93d3cucG9zdGdyZXNx bC5vcmcvZG9jcy8xNy9mdW5jdGlvbnMtYWRtaW4uaHRtbCIgdGFyZ2V0PSJfYmxhbmsiPmh0dHBz Oi8vd3d3LnBvc3RncmVzcWwub3JnL2RvY3MvMTcvZnVuY3Rpb25zLWFkbWluLmh0bWw8L2E+PGJy IC8+CkRlc2NyaXB0aW9uOjxiciAvPjwvYmxvY2txdW90ZT48L2Jsb2NrcXVvdGU+PGRpdj48YnIg Lz48L2Rpdj48ZGl2IGNsYXNzPSI5ZDI2NjJkNGMwM2U2YjlmM2JiOWE0MzBhNDJmNzRlNTgxYmY4 ZTM2MWNlYmIyYzZkNjRmYjRkNjg0MmQ2ZWJnbWFpbF9kZWZhdWx0IiBzdHlsZT0iZm9udC1mYW1p bHk6J2FyaWFsJyAsICdoZWx2ZXRpY2EnICwgc2Fucy1zZXJpZiI+WWVhaCwgdGhpcyBjbGFyaWZp Y2F0aW9uIGp1c3Qgd2Fzbid0IGJhY2stcGF0Y2hlZC48L2Rpdj48ZGl2IGNsYXNzPSI5ZDI2NjJk NGMwM2U2YjlmM2JiOWE0MzBhNDJmNzRlNTgxYmY4ZTM2MWNlYmIyYzZkNjRmYjRkNjg0MmQ2ZWJn bWFpbF9kZWZhdWx0IiBzdHlsZT0iZm9udC1mYW1pbHk6J2FyaWFsJyAsICdoZWx2ZXRpY2EnICwg c2Fucy1zZXJpZiI+PGJyIC8+PC9kaXY+PGRpdiBjbGFzcz0iOWQyNjYyZDRjMDNlNmI5ZjNiYjlh NDMwYTQyZjc0ZTU4MWJmOGUzNjFjZWJiMmM2ZDY0ZmI0ZDY4NDJkNmViZ21haWxfZGVmYXVsdCIg c3R5bGU9ImZvbnQtZmFtaWx5OidhcmlhbCcgLCAnaGVsdmV0aWNhJyAsIHNhbnMtc2VyaWYiPjxh IGhyZWY9Imh0dHBzOi8vd3d3LnBvc3RncmVzcWwub3JnL2RvY3MvMTgvZnVuY3Rpb25zLWFkbWlu Lmh0bWwjRlVOQ1RJT05TLUFETUlOLVNFVCI+aHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9j cy8xOC9mdW5jdGlvbnMtYWRtaW4uaHRtbCNGVU5DVElPTlMtQURNSU4tU0VUPC9hPjwvZGl2Pjxk aXYgY2xhc3M9IjlkMjY2MmQ0YzAzZTZiOWYzYmI5YTQzMGE0MmY3NGU1ODFiZjhlMzYxY2ViYjJj NmQ2NGZiNGQ2ODQyZDZlYmdtYWlsX2RlZmF1bHQiIHN0eWxlPSJmb250LWZhbWlseTonYXJpYWwn ICwgJ2hlbHZldGljYScgLCBzYW5zLXNlcmlmIj48YnIgLz48L2Rpdj48ZGl2IGNsYXNzPSI5ZDI2 NjJkNGMwM2U2YjlmM2JiOWE0MzBhNDJmNzRlNTgxYmY4ZTM2MWNlYmIyYzZkNjRmYjRkNjg0MmQ2 ZWJnbWFpbF9kZWZhdWx0IiBzdHlsZT0iZm9udC1mYW1pbHk6J2FyaWFsJyAsICdoZWx2ZXRpY2En ICwgc2Fucy1zZXJpZiI+InNldF9jb25maWcgYWNjZXB0cyB0aGUgTlVMTCB2YWx1ZSBmb3IgbmV3 X3ZhbHVlLCBidXQgYXMgc2V0dGluZ3MgY2Fubm90IGJlIG51bGwsIGl0IGlzIGludGVycHJldGVk IGFzIGEgcmVxdWVzdCB0byByZXNldCB0aGUgc2V0dGluZyB0byBpdHMgZGVmYXVsdCB2YWx1ZS4i PC9kaXY+PGRpdiBjbGFzcz0iOWQyNjYyZDRjMDNlNmI5ZjNiYjlhNDMwYTQyZjc0ZTU4MWJmOGUz NjFjZWJiMmM2ZDY0ZmI0ZDY4NDJkNmViZ21haWxfZGVmYXVsdCIgc3R5bGU9ImZvbnQtZmFtaWx5 OidhcmlhbCcgLCAnaGVsdmV0aWNhJyAsIHNhbnMtc2VyaWYiPjxiciAvPjwvZGl2PjxkaXYgY2xh c3M9IjlkMjY2MmQ0YzAzZTZiOWYzYmI5YTQzMGE0MmY3NGU1ODFiZjhlMzYxY2ViYjJjNmQ2NGZi NGQ2ODQyZDZlYmdtYWlsX2RlZmF1bHQiIHN0eWxlPSJmb250LWZhbWlseTonYXJpYWwnICwgJ2hl bHZldGljYScgLCBzYW5zLXNlcmlmIj5EYXZpZCBKLjwvZGl2PjxkaXYgY2xhc3M9IjlkMjY2MmQ0 YzAzZTZiOWYzYmI5YTQzMGE0MmY3NGU1ODFiZjhlMzYxY2ViYjJjNmQ2NGZiNGQ2ODQyZDZlYmdt YWlsX2RlZmF1bHQiIHN0eWxlPSJmb250LWZhbWlseTonYXJpYWwnICwgJ2hlbHZldGljYScgLCBz YW5zLXNlcmlmIj48YnIgLz48L2Rpdj48L2Rpdj48L2Rpdj4KPC9ibG9ja3F1b3RlPjwvYmxvY2tx dW90ZT4=