Re: BUG #16726: Invalid input syntax is not a useful error message

> On Nov 18, 2020, at 15:55, PG Bug reporting form <noreply(at)postgresql(dot)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, displayed in five groups separated by hyphens, in the form 8-4-4-4-12 for a total of 36 characters (32 hexadecimal characters and 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(at)thebuild(dot)com