Re: Writing aggregate functions in stored functions?

From: Jerzy Tomasik <tomasik_at_datapacket.net>
Date: Fri, 27 Jul 2001 20:54:34 -0700
Message-ID: <9jtd31$bm6$1@news.chatlink.com>

Thanks for the info. Yes, coding my own aggregate function is exactly what I'm looking for. I chose an example mixing MEDIAN with MIN/MAX (builtins) to show that I would like to use time in the same context.

I may have to look at 9i sooner than I was planning.

Jerzy

"John Russell" <johnrussell10_at_home.com> wrote in message news:chg2mtk0a03qd4845nd6em83icotklil7j_at_4ax.com...
> 9i lets you code your own aggregate functions. Not sure if that's what
> you're asking, since the ones you cite (other than median) are
> built-ins.
>
> If you want to get MIN etc. for subsets of the data, you can use the
> OVER( ) clause. The syntax inside OVER( ) varies, but with a simple
> GROUP BY it would be something like "MIN(sal) OVER( PARTITION BY
> DEPT_NO )".
>
Received on Fri Jul 27 2001 - 22:54:34 CDT