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.98.2) (envelope-from ) id 1xFJcF-00000001ayj-0p7A for pgsql-docs@arkaria.postgresql.org; Fri, 09 Oct 2026 23:03:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1xFJ1b-00000001RWY-1wZS for pgsql-docs@arkaria.postgresql.org; Fri, 09 Oct 2026 22:25:11 +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.98.2) (envelope-from ) id 1xFJ1b-00000001RWQ-0dxH for pgsql-docs@lists.postgresql.org; Fri, 09 Oct 2026 22:25:11 +0000 Received: from mail-wm1-x32b.google.com ([2a00:1450:4864:20::32b]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1xFJ1Y-00000001Ieu-3MrX for pgsql-docs@lists.postgresql.org; Fri, 09 Oct 2026 22:25:10 +0000 Received: by mail-wm1-x32b.google.com with SMTP id 5b1f17b1804b1-4a161d9b8c7so1675815e9.3 for ; Fri, 09 Oct 2026 15:25:08 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1791584708; x=1792189508; darn=lists.postgresql.org; h=mime-version:user-agent:content-type:references:in-reply-to:date:cc :to:from:subject:message-id:from:to:cc:subject:date:message-id :reply-to:content-type; bh=WTWurzn1gHAlePKOBW8x6662dmxasLQdd1Q4RjX73ts=; b=Y35A4V7UjcHC9a/UHJp8jYrRSAL91Lh3AGqgBaLqOXkQsIa57z1DMj0DeukjLLSmQ8 h+4WOj9D69LLD8JcZLxBP/fF+PSAmQnhmQy9VIVy+8g6BCGxAvqg3hzAAhUKAHA6ibBd mrRScW3Hjgs8yggSuJQK3DvpYjnDy/j4+aDTBJcsTFFiDLXs2z9RxiL//WIK7x4Wxsi6 IOZyxgbU7I2/ZwiwHT7N7eLkis0U0nJYSC+YWRhhYt4hd2SDCWXuRYd7wVshFs3C7r8m HMv4ln50mmzKt67vRZhYUM++z+9QexWObTgJUtFGSIYt2tuVtdSiW3uu/epJrjByv3uP B1ug== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20260707; t=1791584708; x=1792189508; h=mime-version:user-agent:content-type:references:in-reply-to:date:cc :to:from:subject:message-id:x-gm-gg:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to:content-type; bh=WTWurzn1gHAlePKOBW8x6662dmxasLQdd1Q4RjX73ts=; b=GQPg92S+wJ0VyVdXqnB8mwIHa4UoyuSimr+AuOsS4BI7x3Y5yeURcpA4b8YdYJZGcj odl3rK5gtJi1asMVvhpX1E2V0Mm5XIIrZJ1ZpOOkcm+69YIc0UGFuo3w8tbQ8gJVCe+J ibpEUTXiawu+uX3NgToE2aljM1YbPsB3BTemp3N1j1j9YPX+tZ7CGlE0udOHE+Q9E9mO 4siFfMyZVxlBp/nMx+A6MH8rylCUFRdO6jaPKron2QYYQZKXCtkPxtA5i1co4SAUu5CQ 0CTbJUXL0tNc+WK7FEmRnJWPEVcGrA2UrzoiBsSb4RQQzc4pot2m3qVZmmbG52TXQ1CQ iyWg== X-Forwarded-Encrypted: i=1; AKwUvByr27G22aEzwlXiiFFZze1gDDWcL+Pr+6CMv5rKDyHFrQJfr+5frawWyUDa6Tv2tqYe/E/kOvFL5R+2@lists.postgresql.org X-Gm-Message-State: AFq9FYKDxgt7fIOaROZLnSWSHU9YInKCc7RC1nqM3Zh5+y3Z+AsrNuBu baopubrK9lxDOaCY4QgprCbirZHUwixW3IMiMMBcL6HZYLdWn45ASQefQZKsQT5Sj6k= X-Gm-Gg: AYBFou2B+GCnkJ4u6e7XalDHBV/bNdKyBlWIHdb4KXk+HHGXh9RPx+kg0igLd53qrzY LX4JJlGuiTGzRPZv11+yRLV+Bi9Cl3EeZPuh8V/4qGvc8bHcbaAC0pgXm4rn5TCCmcginXFh4lv 898wdzpfbrp2cZ8v8MkFhSrEEKt9xpGWolxTyVqMNLpcu2+6JmDczNRO+YBAYVzyOAxoGu7B4NJ yhinNxAVaa8qXqHUs2e5ivyuJAiARsnLsxPdZRa+hcG3oixIyBCqgGurLl//+lPxcTNREwmRRet LYw83D2+tAa4rdPaEFJi5NwxoeKsKihzqV5PWCJ+U4FAeSykTC9zgtdbLbn/CrE5VKhHmqye8nI lsZLBELWJ6C4a/RDAL7Fl7zl1MzfzYHMOSK71V/hFI4DT8MLKGvIcC7O8i2dDOduV09YQGBcyFx pO+NTAxI1R2QmQNX5QNUnmD6vtKjFqoAL6/xOeUIXib0AJGeF3ll4UYjntJYIc9qcHDvJlb5Bft Ld/H7G1Z4kVjsIdW4PbZcgYo5o5L+s= X-Received: by 2002:a05:600d:82c7:b0:4a0:17a:8844 with SMTP id 5b1f17b1804b1-4a18e446454mr69714445e9.1.1791584708073; Fri, 09 Oct 2026 15:25:08 -0700 (PDT) Received: from laurenz.albe-K4N0CV00F97414D ([2001:871:270:b677:677f:591c:a18a:2956]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-4a18bf35930sm83443615e9.13.2026.10.09.15.25.07 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 09 Oct 2026 15:25:07 -0700 (PDT) Message-ID: <176ada94989db19564e580b48c2b44be94a06d3e.camel@cybertec.at> Subject: Re: Table 9.46. UUID Extraction Functions From: Laurenz Albe To: Tom Lane Cc: y.saburov@gmail.com, pgsql-docs@lists.postgresql.org Date: Sat, 10 Oct 2026 00:25:06 +0200 In-Reply-To: <2565626.1791524131@sss.pgh.pa.us> References: <179143326813.1061054.14714458907175925072@wrigleys.postgresql.org> <15c6905385e3ca36756eefd06e73be57c9e6ae72.camel@cybertec.at> <2519947.1791477667@sss.pgh.pa.us> <419b7321d71f70a9390ea6a958525468473ba8c3.camel@cybertec.at> <2558476.1791516774@sss.pgh.pa.us> <2565626.1791524131@sss.pgh.pa.us> Content-Type: multipart/mixed; boundary="=-GbnLxIzTd3w7lRbfeW/v" User-Agent: Evolution 3.60.2 (3.60.2-2.fc44) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --=-GbnLxIzTd3w7lRbfeW/v Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Fri, 2026-10-09 at 01:35 -0400, Tom Lane wrote: > Laurenz Albe writes: > > On Thu, 2026-10-08 at 23:32 -0400, Tom Lane wrote: > > > I still wonder whether there's another solution path though. > > > We settled on &zwsp; because it fixed the major issue here, > > > but that doesn't mean there isn't a better answer. >=20 > > I think that an improved version could look as follows: >=20 > > uuid_extract_timestamp( > > '019535d9-3df7-79fb-b466-fa907fa17f9e'::uuid > > ) =E2=86=92 2025-02-23 21:46:24.503-05 >=20 > Hmm, yeah, that could work so far as the PDF line-break problem > is concerned. Would it look too odd to HTML readers? >=20 > > Also, not everything (query results etc.) are likely to be copied and > > pasted by users. So I guess the way forward would be for me to spend > > some time with this. But then - is it *that* important? >=20 > Yup, that. If you want to press forward, have at it; I'm willing > to push fixes in this area. I felt inspired enough to take a look, and I found only three places that looked like likely things that someone might copy and paste. The first didn't actually need a line break in either the US letter or A4 format, so I simply removed the &zwsp;. I wonder if some other documentation format might need it though... For the UUID functions that the complaint was about, I simply added regular spaces inside the parentheses, which in HTML looks like uuid_extract_version( '41db1265-8bc1-4ab3-992f-885799a4af1d'::uuid ) =E2= =86=92 4 I'd say that that is acceptable. Yours, Laurenz Albe --=-GbnLxIzTd3w7lRbfeW/v Content-Disposition: attachment; filename="v1-0001-Remove-some-zero-width-spaces-in-the-docs.patch" Content-Transfer-Encoding: base64 Content-Type: text/x-patch; name="v1-0001-Remove-some-zero-width-spaces-in-the-docs.patch"; charset="UTF-8" RnJvbSBkNjM4MzAzMTY2YTRmNjhhYjY3NmFlYjY2ZTcyZjVjYmIyYzRlNmQwIE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBMYXVyZW56IEFsYmUgPGxhdXJlbnouYWxiZUBjeWJlcnRlYy5h dD4KRGF0ZTogU2F0LCAxMCBPY3QgMjAyNiAwMDoxOToxOSArMDIwMApTdWJqZWN0OiBbUEFUQ0gg djFdIFJlbW92ZSBzb21lIHplcm8td2lkdGggc3BhY2VzIGluIHRoZSBkb2NzCgpUbyBhdm9pZCB3 YXJuaW5ncyBhbmQgbGluZXMgdGhhdCBleHRlbmQgYmV5b25kIHRoZSByaWdodCBwYWdlCm1hcmdp biBpbiB0aGUgUERGIGRvY3VtZW50YXRpb24sIHdlIGhhdmUgemVyby13aWR0aCBzcGFjZXMgaW4K dGhlIHNvdXJjZSBhdCBzdHJhdGVnaWMgcGxhY2VzLiAgVGhleSBhcmUgbm90IHZpc2libGUgdG8g dGhlCm5ha2VkIGV5ZSwgYnV0IGFsbG93IEZPUCB0byBicmVhayB0aGUgbGluZS4KCkhvd2V2ZXIs IHNvbWUgb2YgdGhlc2UgemVyby13aWR0aCBzcGFjZXMgd2VyZSBpbiB0aGUgbWlkZGxlIG9mCnRl eHQgdGhhdCBwZW9wbGUgbWlnaHQgY29weSBhbmQgcGFzdGUgZnJvbSB0aGUgSFRNTCBkb2N1bWVu dGF0aW9uLAp3aGljaCBsZWFkcyB0byBteXN0ZXJpb3VzIHN5bnRheCBlcnJvcnMuCgpTY2Fubmlu ZyB0aGUgZG9jdW1lbnRhdGlvbiBmb3IgJnp3c3A7IGlkZW50aWZpZWQgdGhyZWUgcGxhY2VzCnRo YXQgdGhpcyBwYXRjaCBpbXByb3ZlczoKCi0gYW4gSVNPIDg2MDEgaW50ZXJ2YWwgbGl0ZXJhbCBk aWRuJ3QgYWN0dWFsbHkgbmVlZCBhIGxpbmUgYnJlYWsKICBpbiBib3RoIHRoZSBVUyBsZXR0ZXIg YW5kIEE0IGZvcm1hdCwgc28gc2ltcGx5IHJlbW92ZSB0aGUKICB6ZXJvLXdpZHRoIHNwYWNlCgot IHR3byBleGFtcGxlcyBmb3IgdXVpZF9leHRyYWN0X3ZlcnNpb24oKSBoYWQgYSB6ZXJvLXdpZHRo IHNwYWNlCiAgaW4gdGhlIG1pZGRsZSBvZiBhbiBVVUlEIGxpdGVyYWwsIGluc3RlYWQgb2Ygd2hp Y2ggd2UgY2FuCiAgc2ltcGx5IGFkZCByZWd1bGFyIHNwYWNlcyBpbnNpZGUgdGhlIHBhcmVudGhl c2VzCgpSZXBvcnRlZC1CeTogWS4gU2FidXJvdiA8eS5zYWJ1cm92QGdtYWlsLmNvbT4KQXV0aG9y OiBMYXVyZW56IEFsYmUgPGxhdXJlbnouYWxiZUBjeWJlcnRlYy5hdD4KRGlzY3Vzc2lvbjogaHR0 cHM6Ly9wb3N0Z3IuZXMvbS8xNzkxNDMzMjY4MTMuMTA2MTA1NC4xNDcxNDQ1ODkwNzE3NTkyNTA3 MkB3cmlnbGV5cy5wb3N0Z3Jlc3FsLm9yZwotLS0KIGRvYy9zcmMvc2dtbC9kYXRhdHlwZS5zZ21s ICAgICAgIHwgMiArLQogZG9jL3NyYy9zZ21sL2Z1bmMvZnVuYy11dWlkLnNnbWwgfCA0ICsrLS0K IDIgZmlsZXMgY2hhbmdlZCwgMyBpbnNlcnRpb25zKCspLCAzIGRlbGV0aW9ucygtKQoKZGlmZiAt LWdpdCBhL2RvYy9zcmMvc2dtbC9kYXRhdHlwZS5zZ21sIGIvZG9jL3NyYy9zZ21sL2RhdGF0eXBl LnNnbWwKaW5kZXggODk5ODVhYjdiMTYuLmEzODY5ZTIwNTRjIDEwMDY0NAotLS0gYS9kb2Mvc3Jj L3NnbWwvZGF0YXR5cGUuc2dtbAorKysgYi9kb2Mvc3JjL3NnbWwvZGF0YXR5cGUuc2dtbApAQCAt MzA1OCw3ICszMDU4LDcgQEAgU0VMRUNUICcyIHllYXJzIDE1IG1vbnRocyAxMDAgd2Vla3MgOTkg aG91cnMgMTIzNDU2Nzg5IG1pbGxpc2Vjb25kcyc6OmludGVydmFsOwogICAgICAgICAgIDxlbnRy eT48bGl0ZXJhbD5pc29fODYwMTwvbGl0ZXJhbD48L2VudHJ5PgogICAgICAgICAgIDxlbnRyeT5Q MVkyTTwvZW50cnk+CiAgICAgICAgICAgPGVudHJ5PlAzRFQ0SDVNNlM8L2VudHJ5PgotICAgICAg ICAgIDxlbnRyeT5QLTFZLTJNM0QmendzcDtULTRILTVNLTZTPC9lbnRyeT4KKyAgICAgICAgICA8 ZW50cnk+UC0xWS0yTTNEVC00SC01TS02UzwvZW50cnk+CiAgICAgICAgICA8L3Jvdz4KICAgICAg ICAgPC90Ym9keT4KICAgICAgICA8L3Rncm91cD4KZGlmZiAtLWdpdCBhL2RvYy9zcmMvc2dtbC9m dW5jL2Z1bmMtdXVpZC5zZ21sIGIvZG9jL3NyYy9zZ21sL2Z1bmMvZnVuYy11dWlkLnNnbWwKaW5k ZXggN2I2MTgxYjM4ZTcuLjU2ZGU4YWZkNDdjIDEwMDY0NAotLS0gYS9kb2Mvc3JjL3NnbWwvZnVu Yy9mdW5jLXV1aWQuc2dtbAorKysgYi9kb2Mvc3JjL3NnbWwvZnVuYy9mdW5jLXV1aWQuc2dtbApA QCAtMTYxLDExICsxNjEsMTEgQEAKICAgICAgICAgcmV0dXJuIDQuCiAgICAgICAgPC9wYXJhPgog ICAgICAgIDxwYXJhPgotICAgICAgICA8bGl0ZXJhbD51dWlkX2V4dHJhY3RfdmVyc2lvbignNDFk YjEyNjUtOGJjMS00YWIzLTk5MmYtJnp3c3A7ODg1Nzk5YTRhZjFkJzo6dXVpZCk8L2xpdGVyYWw+ CisgICAgICAgIDxsaXRlcmFsPnV1aWRfZXh0cmFjdF92ZXJzaW9uKCAnNDFkYjEyNjUtOGJjMS00 YWIzLTk5MmYtODg1Nzk5YTRhZjFkJzo6dXVpZCApPC9saXRlcmFsPgogICAgICAgICA8cmV0dXJu dmFsdWU+NDwvcmV0dXJudmFsdWU+CiAgICAgICAgPC9wYXJhPgogICAgICAgIDxwYXJhPgotICAg ICAgICA8bGl0ZXJhbD51dWlkX2V4dHJhY3RfdmVyc2lvbignMDE5NTM1ZDktM2RmNy03OWZiLWI0 NjYtJnp3c3A7ZmE5MDdmYTE3ZjllJzo6dXVpZCk8L2xpdGVyYWw+CisgICAgICAgIDxsaXRlcmFs PnV1aWRfZXh0cmFjdF92ZXJzaW9uKCAnMDE5NTM1ZDktM2RmNy03OWZiLWI0NjYtZmE5MDdmYTE3 ZjllJzo6dXVpZCApPC9saXRlcmFsPgogICAgICAgICA8cmV0dXJudmFsdWU+NzwvcmV0dXJudmFs dWU+CiAgICAgICAgPC9wYXJhPjwvZW50cnk+CiAgICAgIDwvcm93PgotLSAKMi41Ni4wCgo= --=-GbnLxIzTd3w7lRbfeW/v--