====== pears.psHealthUniqueUsername ======
<WRAP center round info>
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
</WRAP>

===== Original SQL =====
<code sql>
create function "pears"."psHealthUniqueUsername"( 
  in "StartName" char(100) ) 
returns char(100)
begin
  declare "UName" char(100);
  declare "Inc" integer;
  set "UName" = "StartName";
  set "Inc" = 0;
  while exists(select * from "psHealthPerson" where "username" = "UName") loop
    set "Inc" = "Inc"+1;
    set "UName" = "string"("StartName",' ',"Inc")
  end loop;
  return "UName"
end
</code>