> On Nov 18, 2020, at 15:55, PG Bug reporting form <noreply@postgresql.org> wrote:
>
> I tried to update the uuid-value of a user with a uuid-literal. Since the
> documentation on this is so useless:
> https://www.postgresql.org/docs/13/datatype-uuid.html I had to try and
> finally give up.
The documentation you link to gives the exact syntax, and even gives examples:
> In its canonical textual representation, the 16 octets of a UUID are represented as 32 hexadecimal (base-16) digits,
displayedin five groups separated by hyphens, in the form 8-4-4-4-12 for a total of 36 characters (32 hexadecimal
charactersand 4 hyphens). For example:
>
> 123e4567-e89b-12d3-a456-426614174000
> xxxxxxxx-xxxx-Mxxx-Nxxx-xxxxxxxxxxxx
The error message is exactly correct: You did not give the correct format for the character representation of the UUID.
--
-- Christophe Pettus
xof@thebuild.com