DROP FUNCTION voicemailbox;
CREATE or REPLACE FUNCTION  voicemailbox(varchar, varchar) RETURNS VARCHAR AS
'select voicemailnumber as result from phoneline
 where  phoneline.company = ( select id from company
                              where shortname = $1 and status = ''active'') and
        extension = $2 and phoneline.status <> ''deleted'';
' LANGUAGE SQL;

