pears.psHealthUniqueUsername

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