●SQL: SELECT top_comment, CASE WHEN MP_SID IS NOT NULL THEN 1 END AS CONTENT_CD, PC_IMAGE_FILE_NAME, MP_ID, TO_CHAR(DSP_DATE, 'YYYY/MM/DD'), INTERVIEW_ID, TBL_INTERVIEW.ARTIST_CD, MP.MP_SID, MP.TARGET_LINK FROM TBL_INTERVIEW LEFT JOIN ( SELECT TBL_MONTHLY_PUSH.MP_ID, TBL_MONTHLY_PUSH_LIST.MP_SID, TBL_MONTHLY_PUSH_LIST.TARGET_LINK, TBL_MONTHLY_PUSH_LIST.LINK_TITLE, TBL_MONTHLY_PUSH.ARTIST_CD FROM TBL_MONTHLY_PUSH INNER JOIN TBL_MONTHLY_PUSH_LIST ON TBL_MONTHLY_PUSH.MP_ID = TBL_MONTHLY_PUSH_LIST.MP_ID AND TBL_MONTHLY_PUSH_LIST.LINK_TITLE = 'Interview' ) MP ON TBL_INTERVIEW.INTERVIEW_ID::BPCHAR = MP.TARGET_LINK AND MP.ARTIST_CD = TBL_INTERVIEW.ARTIST_CD WHERE TO_CHAR(DSP_DATE, 'yyyy/mm/dd') LIKE '2004%' ORDER BY DSP_DATE DESCの実行に失敗しました。
ERROR: Unable to identify an operator '=' for types 'character' and 'character varying' You will have to retype this query using an explicit cast