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