Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iBeOB-0003dc-Ea for pgsql-admin@arkaria.postgresql.org; Sat, 21 Sep 2019 12:21:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iBeNA-0002It-Sv for pgsql-admin@arkaria.postgresql.org; Sat, 21 Sep 2019 12:20:20 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iBeNA-0002Ia-AQ for pgsql-admin@lists.postgresql.org; Sat, 21 Sep 2019 12:20:20 +0000 Received: from sonic316-11.consmr.mail.bf2.yahoo.com ([74.6.130.121]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iBeN5-0002OX-VK for pgsql-admin@lists.postgresql.org; Sat, 21 Sep 2019 12:20:19 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1569068413; bh=bzl17liD0ycnIkYBlGnh4hGjVXeYaNWTHdRLMZETdNo=; h=References:In-Reply-To:Cc:From:Subject:Date:To:From:Subject; b=PnQuup8o7CUXh0T4GHIgSWOaotqI0r91EzsFVkvYCmWprDi0EzkGK2UECGN4Y+EDGPFkPDmjjUNrZiuHCOYCDy2H69gL429Z/CcX7DFqa5sbN0fHB7BEf/aQ5HW9MU8wHeZvhEOIceU3nXetOVxdGjYZbB0EKH1E9PyYmqDroqFfCQOzpUI1diycq96aw4uXNiPK+vdFrQSudJo32TyBw849dwYWm9VVPGX0G+96xNpcqpwGEr37BNsV4tu9m8dX6LXRUr4SibYnXH7rivIGzrM4VhT+UL/H7HiQQDFVymdY5wPMcw2uU+SXJtTVEwTz/W42ROAqTayJ0QqTxxs2EA== X-YMail-OSG: XFguoYIVM1n8KROqDWQJmu0lK_z7JeRt9J2LgEG2HnobSRAMsyltzZPZxf5EZO7 vvZbTVuNOEokhcD3AvwTG8yhRPbPkjjAFR4o8LpDz9fHAyuqs7d8aGCMdM.MFpKw2Hrlny2105tQ pJUu5xxpNQ9u3EB47SlvcKe6ACHplQx1AQh_dZtrYzVua9KyNQLT5MxFRJ86eRQhSQNmb9ogOpbl JuCb68hrPMo2E0Td.wbqWoi5bLgWke3n7MSBBy94ePnYfG4shWQg80mflt2I6IbeChfWm72BzgAm tUWvEf_9Pwa0.unt_gyt9IZm9CrxmZcStVOxnr6_Hr6BkYsiVHhvcn70p6DTVNDPltLDvHZDkvGo daJNY_8vZ5p3k_Du1_fhD0862ukBMadK4.39P4myohnKXBmBRskaa8muqttKmQ7a39f0GWXwA2tu s9p9T2QaXcs3cDiSlfFKqPmDndpatCMHHVk4w2fSB5Az9AHnkq6J_wTzZNITxla4aqozEjg7nJGd 6hmFHb7o_loKKKcdlsx4wrdyfwwkzNWQarzeX8SGnEvonbyPgD77VFxVWBd7IhD1N5TIt.Y7CGwm kOG22xmxBkVGBj53JH4rnmm4yhkat9e8nVDn3uqDsKYYR8QHE3MoEt8ZSgXJ6kR9mx0uBW8G.Slf 99OG_aPcTuH7NK_VskoQ_aUX9WQlSgjN7Ygzdr.Wfvh0JieT6L2tZrE6zEBhyX4ZRCHIdkbSR9ed u6f4Z1ozToVMQIuxZWHphPwp0virMC6.Hdx.Rrg30.vSCJqMefjDvoht8bwSLPrJd9UjtIR.GvnU mabpNiu4D15fSx1bSkejAQnfcB1F4KL5sMx8ktiYBcOfAoxWtPmU09wVooS4hvPEFOmvpWnw8LC2 3JTzM4IQ.abN4za_fkZJ5wJYbpmxShTebeR86y3yB2gMpvXN6bMN7.xu9YVw7gzHRsGw2C8WVJ9l uQmtHchEhuLKetXmoZk2J2yoYf4pPPBvud1I.gzQRDRazkynQNsVYoOMLWU780pxX_YJxsLPP0yF Toiy.OyN3GfIxI7eCY5j7nsndLdiZrPk7mZg_vTnFme4xN1XhVPxvJ6wJJOJBgCRcElerzz_ZfOo dLMQO1ukrdJX9xg4LZ8yrDHgjDo8Gf22KnTjIlNj4fmBArI6Ot6_GUhDCeZkRsoiVJvHwph3520W dQjvwAim5k33_CC244tzcPZU5uLcnuO1N949aGPwSZKo7FzOCbaUIkmusztvmbKNi_wPWZ01n0Xw 2hGLnIPeYDkjigGCLjFYpzqgMIS58fimYSvqkg_YE9XBb.8p1G3tvCCQW3oBA7A6soBbU Received: from sonic.gate.mail.ne1.yahoo.com by sonic316.consmr.mail.bf2.yahoo.com with HTTP; Sat, 21 Sep 2019 12:20:13 +0000 Received: by smtp428.mail.bf1.yahoo.com (Oath Hermes SMTP Server) with ESMTPA ID e4a2d144e78f3e57adad8be075830de5; Sat, 21 Sep 2019 12:20:11 +0000 (UTC) References: <290131249.7032562.1568999216076.ref@mail.yahoo.com> <290131249.7032562.1568999216076@mail.yahoo.com> <567497570.7112630.1569015183464@mail.yahoo.com> <343266304.7137386.1569017757225@mail.yahoo.com> Mime-Version: 1.0 (1.0) In-Reply-To: Content-Type: multipart/alternative; boundary=Apple-Mail-4EB0366D-76D1-43A0-B290-E78E34F44EA8 Content-Transfer-Encoding: 7bit Message-Id: Cc: Pgsql-admin X-Mailer: iPad Mail (13G36) From: Pepe TD Vo Subject: Re: Merge statement Date: Sat, 21 Sep 2019 08:20:10 -0400 To: Morris de Oryx List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --Apple-Mail-4EB0366D-76D1-43A0-B290-E78E34F44EA8 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable Thank you all. Will look into it on Monday. Have a pleasant weekend. V/r, Bach Nga Sent from my iPad On Sep 21, 2019, at 1:57 AM, Morris de Oryx wrote: Postgres has had stored functions for ages, but only added stored procedures= in version 11. Historically, you'll see people calling stored functions in P= ostgres "stored procedures" as that's what other folks call them. It didn't m= atter because Postgres only had the one thing. For what's new in Postgres 11= stored procedures, here's a place to look: https://severalnines.com/database-blog/overview-new-stored-procedures-postgr= esql-11 The change you're referring to is that a stored procedure (but not a functio= n) has the ability to manage its own transaction blocks. I actually have no clue...I've only read about the new stored procedures. Bu= t if you're coming from Oracle, you're likely looking for PG 11 stored proce= dures, at least some of the time. --Apple-Mail-4EB0366D-76D1-43A0-B290-E78E34F44EA8 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
Thank you all.  Will look into it= on Monday.

Have a pleasant weekend.
V/r,

Bach Nga

Sent from my iP= ad

On Sep 21, 2019, at 1:57 AM, Morris de Oryx <morrisdeoryx@gmail.com> wrote:

=
Postgres has had stored fu= nctions for ages, but only added stored procedures in version 11. Historical= ly, you'll see people calling stored functions in Postgres "stored procedure= s" as that's what other folks call them. It didn't matter because Postgres o= nly had the one thing. For what's new in Postgres 11 stored procedures, here= 's a place to look:


The change you're referring to is that a store= d procedure (but not a function) has the ability to manage its own transacti= on blocks.

I actually have no clue...I've only read= about the new stored procedures. But if you're coming from Oracle, you're l= ikely looking for PG 11 stored procedures, at least some of the time.
<= div class=3D"gmail_quote">
=
= --Apple-Mail-4EB0366D-76D1-43A0-B290-E78E34F44EA8--