> On 4 Sep 2025, at 11:54, Erik Rijkers 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-8b
On
https://www.postgresql.org/docs/18/functions-uuid.html
there is:
Table 9.46. UUID Extraction Functions
which has these examples:
uuid_extract_version('41db1265-8bc1-4ab3-992f-885799a4af1d'::uuid) → 4
uuid_extract_version('019535d9-3df7-79fb-b466-fa907fa17f9e'::uuid) → 7
In my hands, cop
