PostgreSQL-specific SQL configuration

[lichtin]

For selectCommentsByProcessInstanceId_postgres the type is set as BINARY. Is this required or a typo?

<select id="selectCommentsByProcessInstanceId" parameterType="string" resultMap="commentResultMap">
    select *
    from ACT_HI_COMMENT
    where PROC_INST_ID_ = #{processInstanceId,jdbcType=VARCHAR}
    order by TIME_ desc
  </select>

  <select id="selectCommentsByProcessInstanceId_postgres" parameterType="string" resultMap="commentResultMap_postgres">
    select *
    from ACT_HI_COMMENT
    where PROC_INST_ID_ = #{processInstanceId,jdbcType=BINARY}
    order by TIME_ desc
  </select>‍‍‍‍‍‍‍‍‍‍‍‍‍

[trademak]

Hmm strange, yes I think it's a typo.

Best regards,