[h2] Re: Unnesting multiple array columns

2023-11-18 Thread yusuf welder

[h2] Re: Unnesting multiple array columns

2023-09-17 Thread Abeleshev Artem
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

[h2] Re: Unnesting multiple array columns

2023-09-16 Thread Evgenij Ryazanov
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