NULL behavior as part of an array or row expression has some unusual behaviors that it is best just to memorize:
SELECT NULL::INTEGER[] IS NULL;
?column?
----------
t
SELECT '{}'::INTEGER[] IS NULL;
?column?
----------
f
SELECT '{NULL}'::INTEGER[] IS NULL;
?column?
----------
f
If you're new here, you may want to subscribe to our RSS feed or follow us on Twitter for product announcements, event information, and industry news.
NULLs in Arrays and ROW Expressions (Part 10/11)
