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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/1175625707.2438551.1721475729299%40mail.yahoo.com.
