
BEGIN;

CREATE or REPLACE FUNCTION  mycompanyid(varchar) RETURNS integer SECURITY DEFINER AS'
  select department.company
  FROM   contact left join contact_department on contact_department.contact = contact.id
                 left join department on contact_department.department = department.id
  WHERE  contact.username = $1;
' LANGUAGE SQL;


COMMIT;
