Good day!
I've checked on H2 manual and found that H2 supports unnesting of multiple
arrays (http://www.h2database.com/html/functions.html#unnest). For example:
*select * from unnest(array[1, 2, 3], array['one', 'two', 'three']);*
gives desired results:
*1, one2, two3, three*
But unnest sup
Hello Everybody,
A new version 2.2.224 of H2 is available at http://www.h2database.com
(you may have to click 'Refresh').
This is a patch release, and there are no incompatibilities with
on-disk format of v.2.2.222, so it can be used as drop in
replacement for 2.2.222.
It will be available in
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