Postgres::getOperators PHP Method

getOperators() public method

Returns a list of all operators in the database
public getOperators ( ) : All
return All operators
    function getOperators()
    {
        $c_schema = $this->_schema;
        $this->clean($c_schema);
        // We stick with the subselects here, as you cannot ORDER BY a regtype
        $sql = "\n\t\t\tSELECT\n            \tpo.oid,\tpo.oprname,\n\t\t\t\t(SELECT pg_catalog.format_type(oid, NULL) FROM pg_catalog.pg_type pt WHERE pt.oid=po.oprleft) AS oprleftname,\n\t\t\t\t(SELECT pg_catalog.format_type(oid, NULL) FROM pg_catalog.pg_type pt WHERE pt.oid=po.oprright) AS oprrightname,\n\t\t\t\tpo.oprresult::pg_catalog.regtype AS resultname,\n\t\t        pg_catalog.obj_description(po.oid, 'pg_operator') AS oprcomment\n\t\t\tFROM\n\t\t\t\tpg_catalog.pg_operator po\n\t\t\tWHERE\n\t\t\t\tpo.oprnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname='{$c_schema}')\n\t\t\tORDER BY\n\t\t\t\tpo.oprname, oprleftname, oprrightname\n\t\t";
        return $this->selectSet($sql);
    }
Postgres