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 from foo)); In some cases H2 allows subqueries without parentheses due to historic reasons, but this undocumented syntax was implemented very inconsistently and actually it isn't possible to implement it in reliable way due to syntax conflicts. Don't use it, it is not supported and it may not work in future versions of H2 in places where it works in 2.2.222. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/205acd8a-9de4-45d2-a894-bee45ca2faf5n%40googlegroups.com.
