Today I wanted to define a uuid of value
00000000-0000-0000-0000-000000000000. Being a SQL Server man, I'd usually...
select cast(0x0 as uniqueidentifier);
...but I'm in postgres world now so I whipped out a sensible...
select cast('\x00'::bytea as uuid);
ERROR: cannot cast type bytea to uuid LINE 1: select cast('\x00'::bytea as uuid); ^
If such a chart does exist in the docs, it's well hidden. Google is likewise not super helpful in this regard.
Is there a good documentation reference for default permissible type casts in postgresql?
To be clear, I don't actually care about the uuid