← Back to team overview

maria-developers team mailing list archive

Re: Aggregate stored functions [MDEV-7773]


Hi, Varun!

On Mar 21, Varun Gupta wrote:
> Hi Sergei,
> 4) :create an Item_sum_sp to be able to use aggregate stored functions in
>    queries.
> Does this mean we can have the aggregate stored functions in the SELECT ,
> WHERE etc clauses?can you give me more details about this.

Yes, of course. That's how functions are used, right? :)

  SELECT AVG(x), COUNT(y), MAX(z) FROM t1 WHERE aaa=12 GROUP BY bbb;

for example.

Chief Architect MariaDB
and security@xxxxxxxxxxx

Follow ups