-- When translating fastdial numbers to full numbers, get the contact name as well
CREATE OR REPLACE FUNCTION getfastdial(character varying, character varying, character varying) RETURNS character varying AS '
DECLARE
    _number  varchar;
    _name varchar;
  BEGIN
    IF $1 <> '''' THEN
      SELECT INTO _number, _name number, name FROM fastdial_contact WHERE contact = $1 AND shortnumber = $3;
      IF FOUND THEN
        RETURN _number || ''#'' || _name;
      END IF;
    END IF;
    IF $2 <> '''' THEN
      SELECT INTO _number, _name number, name FROM fastdial_company WHERE company = $2 AND shortnumber = $3;
      IF FOUND THEN
        RETURN _number || ''#'' || _name;
      END IF;
    END IF;
    RETURN ''#'';
  END;
' LANGUAGE plpgsql;

