Yes, I tried that but ARRAY_AGG is creating an array of arrays rather than a single array. Maybe I'm calling it wrong? select ARRAY_AGG(tags) from company When I unnest the aggregation I'm back to square one :-( In other words this: select * from unnest((select ARRAY_AGG(tags) from company));
Is the same as this: select tags from company; -- 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/1175625707.2438551.1721475729299%40mail.yahoo.com.