Sir, I am facing the error Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "merge". when I execute the below query in postgres database. The same works fine in Oracle.
merge into net n using dual on (n.id=:id) when matched then update set Status=:status, lastStatusDate=:lastStatusDate, errorMessage=:errorMessage, errorDetails=:errorDetails when not matched then insert (id,Status, lastStatusDate, errorMessage, errorDetails) values (:id,:status,:lastStatusDate,:errorMessage,:errorDetails)"; Can you please let me know how to resolve it? Thanks, Vinodh.
