Writing aggregate functions in stored functions?

Is it possible to develop an aggregate function (e.g. SUM, AVG, MAX, MIN) as a stored function (or any other way). I would like to be able to perform queries like:

SELECT dept_no, MIN(sal), MEDIAN(sal), MAX(sal) FROM EMP GROUP BY dept_no;

TIA,
Jerzy Received on Fri Jul 27 2001 - 02:00:36 CDT