UUIDASCHAR is a miscellaneous function that returns universally unique identifiers (UUIDs) as CHARACTER values.
If (source_character_uuid) is not specified, UUIDASCHAR creates a new UUID and returns it as a CHARACTER value.
If (source_character_uuid) is specified, UUIDASCHAR converts an existing BLOB UUID to the character form.
The result is NULL if a NULL parameter is supplied.