Hello, In order to be able to generate source code for user-defined aggregate functions in jOOQ, we would like to introspect the INFORMATIONS_SCHEMA for that matter. I can see that the aggregate function is reported in FUNCTION_ALIASES, but not in FUNCTION_COLUMNS
Note, that also the FUNCTION_ALIASES.DATA_TYPE, TYPE_NAME, COLUMN_COUNT and RETURNS_RESULT values are not correct. Now, I have a couple of questions: - What exactly is the difference between org.h2.api.AggregateFunction and org.h2.api.Aggregate? I don't really see the point of this distinction. - Other databases (e.g. Oracle, HSQLDB) have more type safe ways of declaring aggregate functions. In particular, it would be useful if each function instance would have an *exact* signature, rather than an arbitrary signature. This is probably the reason why the FUNCTION_ALIASES table cannot report any concrete information. Do you think there is room for improvement in that area? For further reference, here's a link to the manual: http://www.h2database.com/html/grammar.html#create_aggregate Regards, 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 http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
