Hello, H2 (just like PostgreSQL) currently allows for using the VALUES() constructor as a top-level query, just like a SELECT statement:
VALUES (1), (2) yields C1 -- 1 2 In PostgreSQL, it's also possible to use VALUES as a subquery directly, e.g. as a UNION subquery: values (1), (2) union values (3) Would be great if this worked as well in H2. Cheers, Lukas -- 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 post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
