Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dGt49-0005Ox-As for pgsql-sql@arkaria.postgresql.org; Fri, 02 Jun 2017 20:21:01 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dGt48-0001Xr-Tc for pgsql-sql@arkaria.postgresql.org; Fri, 02 Jun 2017 20:21:00 +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_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dGt37-0006GD-8w for pgsql-sql@postgresql.org; Fri, 02 Jun 2017 20:19:57 +0000 Received: from mail-wm0-x242.google.com ([2a00:1450:400c:c09::242]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1dGt34-0008OT-JF for pgsql-sql@postgresql.org; Fri, 02 Jun 2017 20:19:56 +0000 Received: by mail-wm0-x242.google.com with SMTP id b84so20636946wmh.0 for ; Fri, 02 Jun 2017 13:19:54 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=date:subject:message-id:importance:from:to:cc:mime-version; bh=pHE2XsdhrjLK/9Rm7u0nO6C8C3U1VLNQ4iCVEHCH2PE=; b=Dr+mUkuz/Q9fWZ3Px9pqfbe3e9ZtI/Hnk0ONlSQbkNMrxS6Af+1wPVdgoi5nVjoqSV VLJXvq+Cu2wHYG5GRna3+0HTTWvE8KERVPdbe8Qna/B02bal0AAgVO0zu9Q1Pyigjn5U k2hh4tdX9FrWtur+38bjQYyd/NX1756PihA5PmljXaiN8b/7mh55v6oFi/MKZ+SfAOp8 IwP6OEcSEXTjFNOmBS/mz9mNV9BuEqWlehXUhaa6woLfTkxdSitIMHP2jVP2+bUkncSE J8kZGw/DvYIyWtO0mmtU7webnvUhlO1xac7VUbr1zcwOvcJAaXzypjPW3O8V8vydINNd RNXg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:subject:message-id:importance:from:to:cc :mime-version; bh=pHE2XsdhrjLK/9Rm7u0nO6C8C3U1VLNQ4iCVEHCH2PE=; b=ZFfeiVgYRYHpi20tPuWbF98LW1DdTLfuLzUps1viqpUehmP73LQsUsDr/cNsI9ygzp HIFht9jc+HsRP2EwK5rwImB89qS5OceTKjMLdzezMoGDqsDkcOvoB4qPLPM/yfYyseFm Xx4jZrHHpbb7gXNSuc47oVsZ8fdsLHtMK+wY1/RGHjkK6jhmcRmoLX2E50x3wpiMzTcH iHhtOnZgRuJhXx8QmB1PMlXTVRaS9KGm1er8fzBaS5TI0pQ79J1l3KlwhpLCeF6uoNSR 0XjCdxgJtvxmTdKLfscd7OemSz3DKs09VDmiSWSY/KoEn7etYvJ3weSFT0CXmieXgIK8 Dk9g== X-Gm-Message-State: AODbwcDZqTI3Sx4tAnqgx8Ts3vTZkCGgmwBf/c4fjSrsQ6T9UGbia+vd GYGwJ4Jor8i/p+K6fcc= X-Received: by 10.28.69.143 with SMTP id l15mr694428wmi.116.1496434793619; Fri, 02 Jun 2017 13:19:53 -0700 (PDT) Received: from [192.168.1.34] ([88.243.239.183]) by smtp.gmail.com with ESMTPSA id r10sm3552040wmd.9.2017.06.02.13.19.52 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Fri, 02 Jun 2017 13:19:52 -0700 (PDT) Date: Fri, 02 Jun 2017 23:19:17 +0300 Subject: YNT: Re: YNT: Re: Using bind variable within BEGIN END Message-ID: Importance: normal From: gulsumramazanoglu To: Adrian Klaver , "David G. Johnston" , anand086 Cc: "pgsql-sql@postgresql.org" MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="--_com.android.email_4280969816146620" X-Pg-Spam-Score: -2.0 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-sql Precedence: bulk Sender: pgsql-sql-owner@postgresql.org ----_com.android.email_4280969816146620 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: base64 CiAgICAKVGhhbmsgeW91IGd1eXMgZm9yIGFsbCByZXBsaWVzLCBiZWZvcmUgYXNraW5nIG1vcmUg YW5kIHRha2luZyB5b3VyIHZhbHVibGUgdGltZSBpIG5lZWQgdG8gcmVhZCBzb21lIG1vcmUuLiBp dCB3b3VsZCBiZSB3ZWlyZCBub3QgdG8gYmUgYWJsZSB0byBkbyB0aGF0IGluIHN1Y2ggYSBzdHJv bmcgZGIgbGlrZSBQb3N0Z3JlU1FMIGFzIGl0IGlzLCB0aGUgcmVhc29uIG9mIHF1ZXN0aW9uIG1h cmtzIGlzIGFib3V0IG1lLCBub3QgdGhlIGRiOikgLi4gdGhhbmtzIGFnYWluLi4KCgpTYW1zdW5n IGNpaGF6xLFtZGFuIGfDtm5kZXJpbGRpCgotLS0tLS0tLSBPcmppbmFsIG1lc2FqIC0tLS0tLS0t CktpbWRlbjogQWRyaWFuIEtsYXZlciA8YWRyaWFuLmtsYXZlckBha2xhdmVyLmNvbT4gClRhcmlo OiAyIDA2IDIwMTcgIDExOjAwIFBNICAoR01UKzAyOjAwKSAKQWzEsWPEsTogZ3Vsc3VtcmFtYXph bm9nbHUgPGd1bHN1bXJhbWF6YW5vZ2x1QGdtYWlsLmNvbT4sICJEYXZpZCBHLiBKb2huc3RvbiIg PGRhdmlkLmcuam9obnN0b25AZ21haWwuY29tPiwgYW5hbmQwODYgPGFuYW5kMDg2QGdtYWlsLmNv bT4gCkNjOiBwZ3NxbC1zcWxAcG9zdGdyZXNxbC5vcmcgCktvbnU6IFJlOiBZTlQ6IFJlOiBbU1FM XSBVc2luZyBiaW5kIHZhcmlhYmxlIHdpdGhpbiBCRUdJTiBFTkQgCgpPbiAwNi8wMi8yMDE3IDEx OjM4IEFNLCBndWxzdW1yYW1hemFub2dsdSB3cm90ZToKPiAuLi4gd2hpY2ggd2lsbCBwYXNzIGFy Z3VtZW50cyBhbmQgZ2V0IGJhY2sgYSByZXN1bHQgc2V0LCBpIG1lYW4uLgoKVXNpbmcgUHl0aG9u IGFuZCBwc3ljb3BnMjoKClxkZiBiaWxsaW5nX2RheXMKwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKg wqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqAgTGlzdCBv ZiBmdW5jdGlvbnMKwqAgU2NoZW1hIHzCoMKgwqDCoCBOYW1lwqDCoMKgwqAgfMKgwqDCoMKgIFJl c3VsdCBkYXRhIHR5cGXCoMKgwqDCoCB8wqDCoMKgwqDCoCBBcmd1bWVudCBkYXRhIAp0eXBlc8Kg wqDCoMKgwqDCoCB8wqAgVHlwZQotLS0tLS0tLSstLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLQrC oCBwdWJsaWMgfCBiaWxsaW5nX2RheXMgfCBUQUJMRShiaWxsaW5nX2RhdGUgZGF0ZSkgfCBzdGFy dF9kYXRlIGRhdGUsIAplbmRfZGF0ZSBkYXRlIHwgbm9ybWFsCgoKc2VsZWN0ICogZnJvbSBiaWxs aW5nX2RheXMoJzA1LzAxLzIwMTcnLCAnMDUvMzAvMjAxNycpOwrCoCBiaWxsaW5nX2RhdGUKLS0t LS0tLS0tLS0tLS0KwqAgMjAxNy0wNS0wMQrCoCAyMDE3LTA1LTAyCsKgIDIwMTctMDUtMDMKwqAg MjAxNy0wNS0wNArCoCAyMDE3LTA1LTA1CsKgIDIwMTctMDUtMDgKwqAgMjAxNy0wNS0wOQrCoCAy MDE3LTA1LTEwCsKgIDIwMTctMDUtMTEKwqAgMjAxNy0wNS0xMgrCoCAyMDE3LTA1LTE1CsKgIDIw MTctMDUtMTYKwqAgMjAxNy0wNS0xNwrCoCAyMDE3LTA1LTE4CsKgIDIwMTctMDUtMTkKwqAgMjAx Ny0wNS0yMgrCoCAyMDE3LTA1LTIzCsKgIDIwMTctMDUtMjQKwqAgMjAxNy0wNS0yNQrCoCAyMDE3 LTA1LTI2CsKgIDIwMTctMDUtMjkKwqAgMjAxNy0wNS0zMAoKCmltcG9ydCBwc3ljb3BnMgpjb24g PSBwc3ljb3BnMi5jb25uZWN0KCdkYm5hbWU9KioqKiB1c2VyPSoqKl9hZG1pbiBob3N0PWxvY2Fs aG9zdCcpCmJpbGxfY3VyID0gY29uLmN1cnNvcigpCmJpbGxfY3VyLmV4ZWN1dGUoIlNFTEVDVCAq IEZST00gYmlsbGluZ19kYXlzKCVzLCAlcykiICwgKCcwNS8wMS8yMDE3JywgCicwNS8zMS8yMDE3 JykpCmJpbGxfcnMgPSBiaWxsX2N1ci5mZXRjaGFsbCgpCmZvciByb3cgaW4gYmlsbF9yczoKwqDC oMKgwqAgcHJpbnQocm93WzBdKQoKMjAxNy0wNS0wMQoyMDE3LTA1LTAyCjIwMTctMDUtMDMKMjAx Ny0wNS0wNAoyMDE3LTA1LTA1CjIwMTctMDUtMDgKMjAxNy0wNS0wOQoyMDE3LTA1LTEwCjIwMTct MDUtMTEKMjAxNy0wNS0xMgoyMDE3LTA1LTE1CjIwMTctMDUtMTYKMjAxNy0wNS0xNwoyMDE3LTA1 LTE4CjIwMTctMDUtMTkKMjAxNy0wNS0yMgoyMDE3LTA1LTIzCjIwMTctMDUtMjQKMjAxNy0wNS0y NQoyMDE3LTA1LTI2CjIwMTctMDUtMjkKMjAxNy0wNS0zMAoyMDE3LTA1LTMxCgo+IAo+IAo+IAo+ IFNhbXN1bmcgY2loYXrEsW1kYW4gZ8O2bmRlcmlsZGkKCgotLSAKQWRyaWFuIEtsYXZlcgphZHJp YW4ua2xhdmVyQGFrbGF2ZXIuY29tCg== ----_com.android.email_4280969816146620 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: base64 PGh0bWw+PGhlYWQ+PG1ldGEgaHR0cC1lcXVpdj0iQ29udGVudC1UeXBlIiBjb250ZW50PSJ0ZXh0 L2h0bWw7IGNoYXJzZXQ9VVRGLTgiPjwvaGVhZD48Ym9keT4KICAgIAo8ZGl2PlRoYW5rIHlvdSBn dXlzIGZvciBhbGwgcmVwbGllcywgYmVmb3JlIGFza2luZyBtb3JlIGFuZCB0YWtpbmcgeW91ciB2 YWx1YmxlIHRpbWUgaSBuZWVkIHRvIHJlYWQgc29tZSBtb3JlLi4gaXQgd291bGQgYmUgd2VpcmQg bm90IHRvIGJlIGFibGUgdG8gZG8gdGhhdCBpbiBzdWNoIGEgc3Ryb25nIGRiIGxpa2UgUG9zdGdy ZVNRTCBhcyBpdCBpcywgdGhlIHJlYXNvbiBvZiBxdWVzdGlvbiBtYXJrcyBpcyBhYm91dCBtZSwg bm90IHRoZSBkYjopIC4uIHRoYW5rcyBhZ2Fpbi4uPC9kaXY+PGRpdj48YnI+PC9kaXY+PGRpdj48 YnI+PC9kaXY+PGRpdj48YnI+PC9kaXY+PGRpdiBpZD0iY29tcG9zZXJfc2lnbmF0dXJlIj48ZGl2 IHN0eWxlPSJmb250LXNpemU6ODUlO2NvbG9yOiM1NzU3NTciPlNhbXN1bmcgY2loYXrEsW1kYW4g Z8O2bmRlcmlsZGk8L2Rpdj48L2Rpdj48YnI+PGJyPi0tLS0tLS0tIE9yamluYWwgbWVzYWogLS0t LS0tLS08YnI+S2ltZGVuOiBBZHJpYW4gS2xhdmVyICZsdDthZHJpYW4ua2xhdmVyQGFrbGF2ZXIu Y29tJmd0OyA8YnI+VGFyaWg6IDIgMDYgMjAxNyAgMTE6MDAgUE0gIChHTVQrMDI6MDApIDxicj5B bMSxY8SxOiBndWxzdW1yYW1hemFub2dsdSAmbHQ7Z3Vsc3VtcmFtYXphbm9nbHVAZ21haWwuY29t Jmd0OywgIkRhdmlkIEcuIEpvaG5zdG9uIiAmbHQ7ZGF2aWQuZy5qb2huc3RvbkBnbWFpbC5jb20m Z3Q7LCBhbmFuZDA4NiAmbHQ7YW5hbmQwODZAZ21haWwuY29tJmd0OyA8YnI+Q2M6IHBnc3FsLXNx bEBwb3N0Z3Jlc3FsLm9yZyA8YnI+S29udTogUmU6IFlOVDogUmU6IFtTUUxdIFVzaW5nIGJpbmQg dmFyaWFibGUgd2l0aGluIEJFR0lOIEVORCA8YnI+PGJyPk9uIDA2LzAyLzIwMTcgMTE6MzggQU0s IGd1bHN1bXJhbWF6YW5vZ2x1IHdyb3RlOjxicj4mZ3Q7IC4uLiB3aGljaCB3aWxsIHBhc3MgYXJn dW1lbnRzIGFuZCBnZXQgYmFjayBhIHJlc3VsdCBzZXQsIGkgbWVhbi4uPGJyPjxicj5Vc2luZyBQ eXRob24gYW5kIHBzeWNvcGcyOjxicj48YnI+XGRmIGJpbGxpbmdfZGF5czxicj4mbmJzcDsmbmJz cDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsm bmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJz cDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsm bmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsgTGlzdCBvZiBmdW5jdGlv bnM8YnI+Jm5ic3A7IFNjaGVtYSB8Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7IE5hbWUmbmJzcDsm bmJzcDsmbmJzcDsmbmJzcDsgfCZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyBSZXN1bHQgZGF0YSB0 eXBlJm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7IHwmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJz cDsgQXJndW1lbnQgZGF0YSA8YnI+dHlwZXMmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsm bmJzcDsgfCZuYnNwOyBUeXBlPGJyPi0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0t PGJyPiZuYnNwOyBwdWJsaWMgfCBiaWxsaW5nX2RheXMgfCBUQUJMRShiaWxsaW5nX2RhdGUgZGF0 ZSkgfCBzdGFydF9kYXRlIGRhdGUsIDxicj5lbmRfZGF0ZSBkYXRlIHwgbm9ybWFsPGJyPjxicj48 YnI+c2VsZWN0ICogZnJvbSBiaWxsaW5nX2RheXMoJzA1LzAxLzIwMTcnLCAnMDUvMzAvMjAxNycp Ozxicj4mbmJzcDsgYmlsbGluZ19kYXRlPGJyPi0tLS0tLS0tLS0tLS0tPGJyPiZuYnNwOyAyMDE3 LTA1LTAxPGJyPiZuYnNwOyAyMDE3LTA1LTAyPGJyPiZuYnNwOyAyMDE3LTA1LTAzPGJyPiZuYnNw OyAyMDE3LTA1LTA0PGJyPiZuYnNwOyAyMDE3LTA1LTA1PGJyPiZuYnNwOyAyMDE3LTA1LTA4PGJy PiZuYnNwOyAyMDE3LTA1LTA5PGJyPiZuYnNwOyAyMDE3LTA1LTEwPGJyPiZuYnNwOyAyMDE3LTA1 LTExPGJyPiZuYnNwOyAyMDE3LTA1LTEyPGJyPiZuYnNwOyAyMDE3LTA1LTE1PGJyPiZuYnNwOyAy MDE3LTA1LTE2PGJyPiZuYnNwOyAyMDE3LTA1LTE3PGJyPiZuYnNwOyAyMDE3LTA1LTE4PGJyPiZu YnNwOyAyMDE3LTA1LTE5PGJyPiZuYnNwOyAyMDE3LTA1LTIyPGJyPiZuYnNwOyAyMDE3LTA1LTIz PGJyPiZuYnNwOyAyMDE3LTA1LTI0PGJyPiZuYnNwOyAyMDE3LTA1LTI1PGJyPiZuYnNwOyAyMDE3 LTA1LTI2PGJyPiZuYnNwOyAyMDE3LTA1LTI5PGJyPiZuYnNwOyAyMDE3LTA1LTMwPGJyPjxicj48 YnI+aW1wb3J0IHBzeWNvcGcyPGJyPmNvbiA9IHBzeWNvcGcyLmNvbm5lY3QoJ2RibmFtZT0qKioq IHVzZXI9KioqX2FkbWluIGhvc3Q9bG9jYWxob3N0Jyk8YnI+YmlsbF9jdXIgPSBjb24uY3Vyc29y KCk8YnI+YmlsbF9jdXIuZXhlY3V0ZSgiU0VMRUNUICogRlJPTSBiaWxsaW5nX2RheXMoJXMsICVz KSIgLCAoJzA1LzAxLzIwMTcnLCA8YnI+JzA1LzMxLzIwMTcnKSk8YnI+YmlsbF9ycyA9IGJpbGxf Y3VyLmZldGNoYWxsKCk8YnI+Zm9yIHJvdyBpbiBiaWxsX3JzOjxicj4mbmJzcDsmbmJzcDsmbmJz cDsmbmJzcDsgcHJpbnQocm93WzBdKTxicj48YnI+MjAxNy0wNS0wMTxicj4yMDE3LTA1LTAyPGJy PjIwMTctMDUtMDM8YnI+MjAxNy0wNS0wNDxicj4yMDE3LTA1LTA1PGJyPjIwMTctMDUtMDg8YnI+ MjAxNy0wNS0wOTxicj4yMDE3LTA1LTEwPGJyPjIwMTctMDUtMTE8YnI+MjAxNy0wNS0xMjxicj4y MDE3LTA1LTE1PGJyPjIwMTctMDUtMTY8YnI+MjAxNy0wNS0xNzxicj4yMDE3LTA1LTE4PGJyPjIw MTctMDUtMTk8YnI+MjAxNy0wNS0yMjxicj4yMDE3LTA1LTIzPGJyPjIwMTctMDUtMjQ8YnI+MjAx Ny0wNS0yNTxicj4yMDE3LTA1LTI2PGJyPjIwMTctMDUtMjk8YnI+MjAxNy0wNS0zMDxicj4yMDE3 LTA1LTMxPGJyPjxicj4mZ3Q7IDxicj4mZ3Q7IDxicj4mZ3Q7IDxicj4mZ3Q7IFNhbXN1bmcgY2lo YXrEsW1kYW4gZ8O2bmRlcmlsZGk8YnI+PGJyPjxicj4tLSA8YnI+QWRyaWFuIEtsYXZlcjxicj5h ZHJpYW4ua2xhdmVyQGFrbGF2ZXIuY29tPGJyPjwvYm9keT48L2h0bWw+ ----_com.android.email_4280969816146620--