drop function mazurek(integer);

CREATE FUNCTION mazurek (integer) RETURNS varchar AS '

DECLARE

      master_id_in alias for $1;
      master_count   integer;
      detail_count   integer;
   BEGIN
      SELECT into master_count count(*) FROM master;
      SELECT into detail_count count(*) FROM detail
         WHERE master_id_in=master_id;
      if master_count>detail_count
         then  RETURN  ''more references in master than in detail'';
      end if;
      if master_count<detail_count
         then  RETURN  ''less references in master than in detail'';
      end if;
      if master_count=detail_count
         then  RETURN  ''same amount of references'';
      end if;
        return rv;

END;
' LANGUAGE 'plpgsql' ;