Why can I use a UUID to sort rows:
SELECT uuid_nil() ORDER BY 1;
But I cannot compute the maximum value:
 ERROR: function max(uuid) does not exist
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
I know that I can cast to a character type or
ORDER BY and
LIMIT 1. I'm just curious as to why I have to use a workaround.