maria-developers team mailing list archive

[Sergei Golubchik <serg@xxxxxxxxxxx>]

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.

Regards,
Sergei
Chief Architect MariaDB
and security@xxxxxxxxxxx