By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TYPE
| recipient | all_null | all_notnull | some_notnull | some_null |
|---|---|---|---|---|
| (foo,1) | f | t | t | f |
| (,2) | f | f | t | t |
| (,) | t | f | f | t |
| null | t | f | f | t |
SELECT 4
CREATE TYPE
| recipient | all_null | all_notnull | some_notnull | some_null |
|---|---|---|---|---|
| (foo,1) | f | t | t | f |
| (,2) | f | f | t | t |
| (,) | t | f | f | t |
| null | t | f | f | t |
SELECT 4