/* web.rest.insertPostTraceResult */ INSERT INTO EVENT_VIDEO_CHASE_RESULT_INFO(EVENT_SEQ, VIDEO_CHASE_NO, CAMERA_NO, CAMERA_DEVICE_ID, VIDEO_CHASE_RESULT_DATE, REG_DATE, RECOGNITION_RATE) VALUES #{event_seq}, CAST(#{video_chase_no} as integer), #{item.Seq}, (SELECT CAMERA_DEVICE_ID FROM CAMERA_INFO_PS WHERE CAMERA_SEQ = #{item.CctvNum}), (SELECT TO_CHAR(#{item.TraceTime}::TIMESTAMPTZ, 'YYYYMMDDHH24MISS')), TO_CHAR(NOW(), 'YYYYMMDDHH24MISS'), #{item.Rate}