MIME-Version: 1.0
References: 
 <CA+hUKG+-2=tq15fLm=MbJhCTA=i-XJ=ZDMWjiWUg_eGH9cfP2Q@mail.gmail.com>
 <CA+hUKGKkt5AcwmkAskvpx7YtXOTq0ntxA3wVa=3YFQNqMkaDVw@mail.gmail.com>
In-Reply-To: 
 <CA+hUKGKkt5AcwmkAskvpx7YtXOTq0ntxA3wVa=3YFQNqMkaDVw@mail.gmail.com>
From: Florents Tselai <florents.tselai@gmail.com>
Date: Tue, 14 Apr 2026 18:32:47 +0300
Message-ID: 
 <CA+v5N42+0S=PwLE_5qqHGPaTJuSWxfU2mw6LaDubJpL-nduhEQ@mail.gmail.com>
Subject: Re: ISBN range table
To: Thomas Munro <thomas.munro@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Content-Type: multipart/mixed; boundary="000000000000f1d686064f6d51d9"
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2Bv5N42%2B0S%3DPwLE_5qqHGPaTJuSWxfU2mw6LaDubJpL-nduhEQ%40mail.gmail.com>
Precedence: bulk

--000000000000f1d686064f6d51d9
Content-Type: multipart/alternative; boundary="000000000000f1d684064f6d51d7"

--000000000000f1d684064f6d51d7
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Tue, Apr 14, 2026 at 6:05=E2=80=AFAM Thomas Munro <thomas.munro@gmail.co=
m> wrote:

> On Sun, Apr 12, 2026 at 11:37=E2=80=AFPM Thomas Munro <thomas.munro@gmail=
.com>
> wrote:
> > A recent-ish thread[1] made me wonder what that big table of data
> > does, and why we have a random update every decade or so, and I came
> > up with the attached.
>
> Fixed a couple of typos and added as commitfest #6676.  The idea is
> that update_isbn.py would become another periodic update task, similar
> to Unicode, contrib/unaccent and the IANA timezone stuff.  I suppose
> running it only for major releases would be enough for such
> non-critical data.  There are also some other much smaller tables in
> this contrib module, but they don't seem to be moving (?) so I didn't
> look at them.
>
> I'm not volunteering today, but a passing thought I had while browsing
> this complicated code full of scary pointer arithmetic is that it
> might be an idea to try to describe the entire EAN3 number space in a
> much simpler single binary-searchable array that maps uint64_t ranges
> to TO_CHAR format strings, with entries that look something like:
>
>  {9780037000000, 9780638999999, "999-9-99-999999-9"}
>

 Nitpick; I'd just use standard python and avoid import requests .

--000000000000f1d684064f6d51d7
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div><br></div></div><br><div class=3D"gm=
ail_quote gmail_quote_container"><div dir=3D"ltr" class=3D"gmail_attr">On T=
ue, Apr 14, 2026 at 6:05=E2=80=AFAM Thomas Munro &lt;<a href=3D"mailto:thom=
as.munro@gmail.com">thomas.munro@gmail.com</a>&gt; wrote:<br></div><blockqu=
ote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left-wid=
th:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-l=
eft:1ex">On Sun, Apr 12, 2026 at 11:37=E2=80=AFPM Thomas Munro &lt;<a href=
=3D"mailto:thomas.munro@gmail.com" target=3D"_blank">thomas.munro@gmail.com=
</a>&gt; wrote:<br>
&gt; A recent-ish thread[1] made me wonder what that big table of data<br>
&gt; does, and why we have a random update every decade or so, and I came<b=
r>
&gt; up with the attached.<br>
<br>
Fixed a couple of typos and added as commitfest #6676.=C2=A0 The idea is<br=
>
that update_isbn.py would become another periodic update task, similar<br>
to Unicode, contrib/unaccent and the IANA timezone stuff.=C2=A0 I suppose<b=
r>
running it only for major releases would be enough for such<br>
non-critical data.=C2=A0 There are also some other much smaller tables in<b=
r>
this contrib module, but they don&#39;t seem to be moving (?) so I didn&#39=
;t<br>
look at them.<br>
<br>
I&#39;m not volunteering today, but a passing thought I had while browsing<=
br>
this complicated code full of scary pointer arithmetic is that it<br>
might be an idea to try to describe the entire EAN3 number space in a<br>
much simpler single binary-searchable array that maps uint64_t ranges<br>
to TO_CHAR format strings, with entries that look something like:<br>
<br>
=C2=A0{9780037000000, 9780638999999, &quot;999-9-99-999999-9&quot;}<br></bl=
ockquote><div><br></div><div>=C2=A0Nitpick; I&#39;d just use standard pytho=
n and avoid import requests .=C2=A0</div></div></div>

--000000000000f1d684064f6d51d7--

--000000000000f1d686064f6d51d9
Content-Type: application/octet-stream; name="stdpy.diff"
Content-Disposition: attachment; filename="stdpy.diff"
Content-Transfer-Encoding: base64
Content-ID: <f_mnys2vy20>
X-Attachment-Id: f_mnys2vy20

ZGlmZiAtLWdpdCBhL2NvbnRyaWIvaXNuL3VwZGF0ZV9pc2JuLnB5IGIvY29udHJpYi9pc24vdXBk
YXRlX2lzYm4ucHkKaW5kZXggNWI0NGI1YzE4ZmYuLjg1NmE2ODI4YzVkIDEwMDY0NAotLS0gYS9j
b250cmliL2lzbi91cGRhdGVfaXNibi5weQorKysgYi9jb250cmliL2lzbi91cGRhdGVfaXNibi5w
eQpAQCAtMSw3ICsxLDggQEAKLSMgVXBkYXRlIElTQk4uaCBmcm9tIHByaW1hcnkgc291cmNlLgor
IyEvdXNyL2Jpbi9lbnYgcHl0aG9uMwogCisjIFVwZGF0ZSBJU0JOLmggZnJvbSBwcmltYXJ5IHNv
dXJjZS4KIGltcG9ydCByZQotaW1wb3J0IHJlcXVlc3RzCitmcm9tIHVybGxpYi5yZXF1ZXN0IGlt
cG9ydCBSZXF1ZXN0LCB1cmxvcGVuCiBpbXBvcnQgeG1sLmV0cmVlLkVsZW1lbnRUcmVlIGFzIEVU
CiAKIFNPVVJDRV9VUkwgPSAiaHR0cHM6Ly93d3cuaXNibi1pbnRlcm5hdGlvbmFsLm9yZy9leHBv
cnRfcmFuZ2VtZXNzYWdlLnhtbCIKQEAgLTcyLDEwICs3Myw5IEBAIGRlZiBnZW5lcmF0ZV90YWJs
ZShyb290LCBnczFfcHJlZml4KToKICAgcmV0dXJuIHRhYmxlX2xpbmVzLCBpbmRleF9saW5lcwog
CiBkZWYgZmV0Y2hfYW5kX3BhcnNlX3NvdXJjZV9kYXRhKCk6Ci0gICAjcmV0dXJuIEVULnBhcnNl
KCd4LnhtbCcpLmdldHJvb3QoKQotICAgcmVzcG9uc2UgPSByZXF1ZXN0cy5nZXQoU09VUkNFX1VS
TCkKLSAgIHJlc3BvbnNlLnJhaXNlX2Zvcl9zdGF0dXMoKQotICAgcmV0dXJuIEVULmZyb21zdHJp
bmcocmVzcG9uc2UudGV4dCkKKyAgICB3aXRoIHVybG9wZW4oU09VUkNFX1VSTCkgYXMgcmVzcG9u
c2U6CisgICAgICAgIGRhdGEgPSByZXNwb25zZS5yZWFkKCkKKyAgICAgICAgcmV0dXJuIEVULmZy
b21zdHJpbmcoZGF0YSkKIAogZGVmIG1lcmdlX2lzYm4oaW5wdXRfbGluZXMpOgogICByb290ID0g
ZmV0Y2hfYW5kX3BhcnNlX3NvdXJjZV9kYXRhKCkK
--000000000000f1d686064f6d51d9--