pears.PersonVacancyShiftMatch

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."PersonVacancyShiftMatch" IS 
{CREATE FUNCTION PersonVacancyShiftMatch( IN @PersonID CHAR(20),IN @VacancyID CHAR(20) ) 
RETURNS DOUBLE
BEGIN
  DECLARE "rv" DOUBLE;
  SET "rv"
     = "DistanceBetweenPostCodes"(
    (SELECT "Person"."PostCode" FROM "Person" WHERE "Person"."PersonID" = @PersonID),
    (SELECT "isnull"("vacancy"."postcode","company"."postcode") FROM "Vacancy" KEY JOIN "Employment" KEY JOIN "Company" WHERE "Vacancy"."VacancyID" = @VacancyID),'Mi');
  IF "rv" < 1 THEN
    RETURN "round"("rv",1)
  ELSE RETURN "round"("rv",0)
  END IF
END
}