CDB_Mode

Jump to bottom

Andrew W. Hill edited this page Jul 21, 2014 · 2 revisions

CREATE OR REPLACE FUNCTION _final_mode(anyarray)
    RETURNS anyelement AS
    $BODY$
        SELECT a
        FROM unnest($1) a
        GROUP BY 1
        ORDER BY COUNT(1) DESC, 1
        LIMIT 1;
    $BODY$
LANGUAGE 'sql' IMMUTABLE;

CREATE AGGREGATE CDB_Mode(anyelement) (
   SFUNC=array_append,
   STYPE=anyarray,
   FINALFUNC=_final_mode, 
   INITCOND='{}' 
);