Re: docs: Table 9.46. UUID Extraction Functions

From: Daniel Gustafsson <daniel(at)yesql(dot)se>
To: Erik Rijkers <er(at)xs4all(dot)nl>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: docs: Table 9.46. UUID Extraction Functions
Date: 2025-09-04 11:04:05
Message-ID: 7E0BDBFE-2FAE-4889-825D-1964F3F959B2@yesql.se
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> On 4 Sep 2025, at 11:54, Erik Rijkers <er(at)xs4all(dot)nl> wrote:

> In my hands, copy/pasting from the website page html intto psql these don't work:
>
> ------
> testdb=# select uuid_extract_version('41db1265-8bc1-4ab3-992f-​885799a4af1d'::uuid);
> ERROR: invalid input syntax for type uuid: "41db1265-8bc1-4ab3-992f-​885799a4af1d"
> LINE 1: select uuid_extract_version('41db1265-8bc1-4ab3-992f-​885799...
> ------
>
> Apparently, that's because of the dash characters used: if I re-type those with simple keyboard-minus chars, the statement works as expected.

I believe it is because there is a &zwsp; encoded before the last group, which
was added in a6524105d20b in order to aid line breaking.

> If I copy/paste the result values of the previous table (9.45. UUID Generation Functions) into the uuid_extract_version() function, then the examples work so there the dash-characters are apparently ok.

There is no zero-width-space character there since those lines aren't long
enough to cause line breaks.

> It's not a huge problem but it would be nice to fix the sgml so that it generates copy/paste runnable examples here.

Agreed, it would be a nice to have, but not a showstopper.

--
Daniel Gustafsson

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Ilia Evdokimov 2025-09-04 11:05:50 Re: Use merge-based matching for MCVs in eqjoinsel
Previous Message Jakub Wartak 2025-09-04 10:56:06 MPTCP - multiplexing many TCP connections through one socket to get better bandwidth