database:functions:pears_canuploadvacancy



pears.CanUploadVacancy

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

Original SQL

CREATE FUNCTION "pears"."CanUploadVacancy"( IN "vacID" CHAR(20) ) 
RETURNS INTEGER
BEGIN
  IF EXISTS(SELECT "Vacancyid" FROM "vacancy" WHERE "vacancyid" = "vacid" AND "status" = 'C') THEN
    RETURN 1
  ELSE RETURN 0
  END IF
END
  • database/functions/pears_canuploadvacancy.txt
  • Last modified: 2026/08/07 19:24
  • by 127.0.0.1