IS NULL
and IS NOT NULL
work for complex types too, so these two should be appropriate:
select * from bla where recipient is not null
select * from bla where recipient is null
IS NULL
and IS NOT NULL
work for complex types too, so these two should be appropriate:
select * from bla where recipient is not null
select * from bla where recipient is null