Postgres::getAggregates PHP Method

getAggregates() public method

Gets all aggregates
public getAggregates ( ) : A
return A recordset
    function getAggregates()
    {
        $c_schema = $this->_schema;
        $this->clean($c_schema);
        $sql = "SELECT p.proname, CASE p.proargtypes[0] WHEN 'pg_catalog.\"any\"'::pg_catalog.regtype THEN NULL ELSE\n\t\t\t   pg_catalog.format_type(p.proargtypes[0], NULL) END AS proargtypes, a.aggtransfn, u.usename,\n\t\t\t   pg_catalog.obj_description(p.oid, 'pg_proc') AS aggrcomment\n\t\t\t   FROM pg_catalog.pg_proc p, pg_catalog.pg_namespace n, pg_catalog.pg_user u, pg_catalog.pg_aggregate a\n\t\t\t   WHERE n.oid = p.pronamespace AND p.proowner=u.usesysid AND p.oid=a.aggfnoid\n\t\t\t   AND p.proisagg AND n.nspname='{$c_schema}' ORDER BY 1, 2";
        return $this->selectSet($sql);
    }
Postgres