Skip to content

Instantly share code, notes, and snippets.

@devodo
devodo / gist:8b39748d65e8185fbd89
Created March 16, 2016 11:43
PostgreSQL create UUID max aggregate function
CREATE OR REPLACE FUNCTION max (uuid, uuid)
RETURNS uuid AS $$
BEGIN
IF $1 IS NULL OR $1 < $2 THEN
RETURN $2;
END IF;
RETURN $1;
END;
$$ LANGUAGE plpgsql;