Re: Merge statement

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Yes, I heard  MERGE is not a command in Postgres but the others said merge statement added stored procedures in version 11

I upgraded my postgresql from 10.6 to 11.1. in AWS, still not work.

thank you,

Bach-Nga

No one in this world is pure and perfect.  If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.
To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)

**Live simply **Love generously **Care deeply **Speak kindly.
*** Genuinely rich *** Faithful talent *** Sharing success


On Monday, September 23, 2019, 10:49:34 AM EDT, Keith <keith@xxxxxxxxxxx> wrote:




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.


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


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux