Hello! Take a look on *Using a Function as a Table* subsection in documentation, here is a link to *User-Defined Functions and Stored Procedures* section: https://h2database.com/html/features.html#user_defined_functions The mentioned subsection is below, unfortunately, it doesn't have an own anchor.
It describes how such functions need to be implemented. They should have java.sql.Connection as their first parameter, and when passed connection has URL "jdbc:columnlist:connection", they don't need to return an actual data, they only need to provide an empty result set with properly configured columns. H2 needs to know names and data types of table columns during compilation of a query. -- 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 visit https://groups.google.com/d/msgid/h2-database/41651af4-2a6a-4ec0-9ed2-3058dab77c7cn%40googlegroups.com.
