Note that you can have aggregates and scalars with the same name, as
long as they have a different number of arguments.
This comes up with the min() and max() functions. The two-or-more
argument versions of these functions are scalars. The one-argument
version is an aggregate.
On 3/9/17, Keith
Ok, I see why you cannot use the same name. Queries of the form:
select func(x) from y;
would be ambiguous if there were both an aggregate func and a scalar func, and
the vdbe code generator uses the type of func (whether aggregate or scaler) to
determine whether to interpret the query as an
2 matches
Mail list logo