The exists operator allows you to check if an argument is not empty nor
null. It returns true if the argument is not empty, and
false if the argument is empty or does not exist.
For example:
FROM order
WHERE items EXISTS
UNNEST items
SELECT { orderno, itemno }
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!