Re: Merge statement

On Mon, Sep 23, 2019 at 10:34 AM Pepe TD Vo <[email protected]> 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