merge statement gives error - Mailing list pgsql-general

From Abhra Kar
Subject merge statement gives error
Date
Msg-id CAFNULEdVuT0WmCqM15_oOsuW3CS9g1oPdQQ8=MW+hH+-hvJkQQ@mail.gmail.com
Whole thread Raw
Responses Re: merge statement gives error
List pgsql-general

Hi,

       Trying to execute the following statement ---- 


merge into ABC as n using dual on (n.id=123)

when matched update set aaa=222, bbb=333

 when not matched insert (id, aaa) values (NEXTVAL(id),555);


but gives syntax error.What should be the proper syntax[ Parameter values are properly passed based on data type].

Thanks 

pgsql-general by date:

Previous
From: Łukasz Jarych
Date:
Subject: Re: Creating complex track changes database - challenge!
Next
From: Tom Kazimiers
Date:
Subject: Re: Unexpected behavior with transition tables in update statementtrigger