Thank you for the answer. It works as expected.
But I realized that it will not solve my original problem I have in mind.
Actually, I'm tryting to come up with some more or less ANSI compliant
solution for the following issue:
I have two (or more) columns in database that represents the state
Hello!
Yes, it is possible, but with valid SQL only.
Subqueries must be enclosed in parentheses, all your queries are incorrect.
Valid queries are
select * from unnest((select bar from foo));
select * from unnest((select baz from foo));
select * from unnest((select bar from foo), (select baz