Re: Merge statement

There is no transaction processing with in a Postgres  function until you
get to Postgres 11.
You can run a merge in Postgres directly through sql.

On Fri, Sep 20, 2019 at 17:33 Pepe TD Vo <[email protected]> wrote:

> yes, this is to migrate from Oracle to Postgres.  I followed this link and
> as same as ora2pg
>
>
> MERGE
> <https://www.postgresql.org/message-id/attachment/23520/sql-merge.html>
>
> MERGE
>
> <https://www.postgresql.org/message-id/attachment/23520/sql-merge.html>
>
>
> 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 Friday, September 20, 2019, 02:21:49 PM EDT, Igor Neyman <
> [email protected]> wrote:
>
>
>
>
>
>
> ERROR:  "application_cdim" is not a known variable
>
> LINE 13:    MERGE INTO APPLICATION_CDIM prod
>
>                        ^
>
> SQL state: 42601
>
> Character: 349
>
>
>
>
>
> There is no MERGE in Postgres.
>
> Is this migrated from Oracle?
>
>
>
> Regards,
>
> Igor Neyman
>