glints
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
jobs_check_duplicate_job(uuid, text, uuid, jsonb)
Parameters
Name
Type
Mode
uuid
IN
text
IN
uuid
IN
jsonb
IN
Definition
BEGIN IF ( SELECT COUNT(*) FROM "Jobs" WHERE "status" = 'OPEN' AND "id" <> $1 AND convert_to_alphanumeric("title"::text) = convert_to_alphanumeric($2) AND "DistrictId" = $3 AND jobs_get_cleaned_description("descriptionRaw") = jobs_get_cleaned_description($4) ) > 0 THEN RETURN FALSE; END IF; RETURN TRUE; END;