Cheap non-aggregate MAX() and AVG() functions

myavg.sql

CREATE OR REPLACE
  FUNCTION MYAVG(VARIADIC NUMERIC[])
  RETURNS NUMERIC
  LANGUAGE SQL
  AS 'SELECT AVG(unnest) FROM UNNEST($1)';

mymax.sql

CREATE OR REPLACE
  FUNCTION MYMAX(VARIADIC INTEGER[])
  RETURNS INTEGER
  LANGUAGE SQL
  AS 'SELECT MAX(unnest) FROM UNNEST($1)';

socialthing=# CREATE OR REPLACE
socialthing-# FUNCTION MAX(VARIADIC INTEGER[])
socialthing-# RETURNS INTEGER
socialthing-# LANGUAGE SQL
socialthing-# AS 'SELECT MAX(unnest) FROM UNNEST($1)';
CREATE FUNCTION
socialthing=# SELECT MAX(1,3,2);

max

3
(1 row)

socialthing=# SELECT max(popularity) FROM topic_results;

max

11248
(1 row)

Sweet. Well, I suppose, absent any other evidence to the contrary, that it's not necessary to do MYAVG()/MYMAX() at all after all. That'd certainly make it syntactically prettier.

That is, to name them MYcrap() instead of just crap(). I'd go back and edit my comment but I suppose that's not possible? Or I'm an idiot.