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 fr
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 o
https://www.timestored.com/data/h2-database-online/?qcode=DROP%20TABLE%20IF%20EXISTS%20weather%3B%0ADROP%20TABLE%20IF%20EXISTS%20cities%3B%0ADROP%20TABLE%20IF%20EXISTS%20sales%3B%0A%0A%0Acreate%20table%20sales(item%20text%2C%20sale_time%20timestamp%2C%20quantity%20int)%3B%0Ainsert%20into%20sales%2