Hi,
Using multiple expressions in "count(distinct ...)" is interesting syntax.
According to my tests, MySQL is the only database that supports it. For
PostgreSQL and H2, you could use the following instead:
select count(distinct (a, b)) from test;
This will work because "(a, b)" is an array of the two elements "a" and "b"
(as in: "select (a, b) from test").
Regards,
Thomas
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
