SELECT (SELECT count(COURSE_TYPE_ID) FROM M_PROGRAM WHERE COURSE_TYPE_ID = 1 AND PROGRAM_STATUS = 1 AND APPLICANT_ONLY is null) as C2, (SELECT count(COURSE_TYPE_ID) FROM M_PROGRAM WHERE COURSE_TYPE_ID = 3 AND PROGRAM_STATUS = 1 AND APPLICANT_ONLY is null) as C3, (SELECT count(COURSE_TYPE_ID) FROM M_PROGRAM WHERE COURSE_TYPE_ID = 4 AND PROGRAM_STATUS = 1 AND APPLICANT_ONLY is null) as C4 FROM M_PROGRAM WHERE 1 = 1 AND PROGRAM_STATUS = 1 AND APPLICANT_ONLY is null Error Description: ERROR: operator does not exist: character varying = integer LINE 2: ...URSE_TYPE_ID) FROM M_PROGRAM WHERE COURSE_TYPE_ID = 1 AND PR... ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.