There is no way to do that currently.
"functions as tables" always has to return the same set of columns, and H2 will then drop the ones that the user did not
request.
For what you want, you would have to implement a custom table:
http://h2database.com/html/features.html#pluggable_tables
--
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 http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.