Hello, I have a simple query in PostgreSQL that I am trying to emulate in H2:SELECT DISTINCT(unnest(tags)) as tags FROM company;
The "tags" column is a varchar array. The query returns a unique list of tags from the "tags" column. When I try to run the same query in H2 2.2.224, I get a Function "unnest" not found error I can get a unique list of tags from a single record like this:SELECT distinct(tags) FROM UNNEST(select tags from company where id=1) as t(tags); But I'm struggling to come up with a query to get a unique list of tags from multiple records. Any suggestions? Thanks in advance,Peter -- 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/943944094.2430433.1721472409881%40mail.yahoo.com.
