Hi Noel,
Thanks for your response.
(1) is creative :) I'd have to do this for both JDBC types and H2 internal
types, I guess... I'm actually not even sure if I can assume to be able to
load the aggregate function implementation class from where I'd be doing
this, so I'd have to probe the funct
On 2014-06-28 09:13 AM, Lukas Eder wrote:
H2's aggregate functions are not "type safe" in that way, so a single aggregate
function implementation can handle all
sorts of combinations for "return type / input arity / input types". In my
opinion, that's why it cannot be reported
correctly thr
Am Freitag, 27. Juni 2014 17:08:34 UTC+2 schrieb Noel Grandin:
>
> On Fri, Jun 27, 2014 at 4:48 PM, Lukas Eder > wrote:
> > - 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 wo
Hi Noel,
Am Freitag, 27. Juni 2014 17:06:19 UTC+2 schrieb Noel Grandin:
>
> On Fri, Jun 27, 2014 at 4:48 PM, Lukas Eder > wrote:
> > - 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.
>
> See
On Fri, Jun 27, 2014 at 4:48 PM, Lukas Eder wrote:
> - 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 pro
On Fri, Jun 27, 2014 at 4:48 PM, Lukas Eder wrote:
> - 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.
See the comment in the JavaDoc for AggregateFunction:
"Please note this interface only has limi
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_ALI