Re: Merge statement

[Keith <keith@xxxxxxxxxxx>]

On Mon, Sep 23, 2019 at 10:34 AM Pepe TD Vo <pepevo@xxxxxxxxx> wrote:

good morning, happy Monday.

fyi, I upgraded postgres in AWS to 11.1 and the merge function for procedure is still not working. Still complained the same error that: 

ERROR:  "ecisdrdm.application_cdim" is not a known variable

LINE 14: MERGE INTO ecisdrdm.application_cdim prod

                    ^

SQL state: 42601

Character: 348

v/r,

Bach-Nga

As others have said, MERGE is not a command in Postgres. The document you linked is a development document from a long time ago when it was proposed at one time, but it was never accepted. Please reference the actual PostgreSQL documentation.

https://www.postgresql.org/docs/current/index.html

If you need UPSERT like behavior, look at the INSERT ... ON CONFLICT statement.

https://www.postgresql.org/docs/current/sql-insert.html