pgsql: Improve the handling of result type coercions in SQL functions.

Tom Lane <[email protected]> Wed, 08 Jan 2020 16:08:27 +0000
Newsgroups gmane.comp.db.postgresql.devel.cvs
Message-ID <[email protected]>
--===============5698257757901136976==
Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: base64

SW1wcm92ZSB0aGUgaGFuZGxpbmcgb2YgcmVzdWx0IHR5cGUgY29lcmNpb25zIGluIFNRTCBmdW5j
dGlvbnMuCgpVc2UgdGhlIHBhcnNlcidzIHN0YW5kYXJkIHR5cGUgY29lcmNpb24gbWFjaGluZXJ5
IHRvIGNvbnZlcnQgdGhlCm91dHB1dCBjb2x1bW4ocykgb2YgYSBTUUwgZnVuY3Rpb24ncyBmaW5h
bCBTRUxFQ1Qgb3IgUkVUVVJOSU5HCnRvIHRoZSB0eXBlKHMpIHRoZXkgc2hvdWxkIGhhdmUgYWNj
b3JkaW5nIHRvIHRoZSBmdW5jdGlvbidzIGRlY2xhcmVkCnJlc3VsdCB0eXBlLiAgV2UnbGwgYWxs
b3cgYW55IGNhc2Ugd2hlcmUgYW4gYXNzaWdubWVudC1sZXZlbApjb2VyY2lvbiBpcyBhdmFpbGFi
bGUuICBQcmV2aW91c2x5LCB3ZSBmYWlsZWQgdW5sZXNzIHRoZSByZXF1aXJlZApjb2VyY2lvbiB3
YXMgYSBiaW5hcnktY29tcGF0aWJsZSBvbmUgKGFuZCB0aGUgZG9jdW1lbnRhdGlvbiBpZ25vcmVk
CnRoaXMsIGZhbHNlbHkgY2xhaW1pbmcgdGhhdCB0aGUgdHlwZXMgbXVzdCBtYXRjaCBleGFjdGx5
KS4KCk5vdGFibHksIHRoZSBjb2VyY2lvbiBub3cgYWNjb3VudHMgZm9yIHR5cG1vZHMsIHNvIHRo
YXQgY2FzZXMgd2hlcmUKYSBTUUwgZnVuY3Rpb24gaXMgZGVjbGFyZWQgdG8gcmV0dXJuIGEgY29t
cG9zaXRlIHR5cGUgd2hvc2UgY29sdW1ucwphcmUgdHlwbW9kLWNvbnN0cmFpbmVkIG5vdyBiZWhh
dmUgYXMgb25lIHdvdWxkIGV4cGVjdC4gIEFyZ3VhYmx5CnRoaXMgYXNwZWN0IGlzIGEgYnVnIGZp
eCwgYnV0IHRoZSBvdmVyYWxsIGJlaGF2aW9yYWwgY2hhbmdlIGhlcmUKc2VlbXMgdG9vIGxhcmdl
IHRvIGNvbnNpZGVyIGJhY2stcGF0Y2hpbmcuCgpBIG5pY2Ugc2lkZS1lZmZlY3QgaXMgdGhhdCBm
dW5jdGlvbnMgY2FuIG5vdyBiZSBpbmxpbmVkIGluIGEKZmV3IGNhc2VzIHdoZXJlIHdlIHByZXZp
b3VzbHkgZmFpbGVkIHRvIGRvIHNvIGJlY2F1c2Ugb2YgdHlwZQptaXNtYXRjaGVzLgoKRGlzY3Vz
c2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS8xODkyOS4xNTc0ODk1NDMwQHNzcy5wZ2gucGEudXMK
CkJyYW5jaAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdy
ZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi85MTNiYmQ4OGRjNmI4NTljNzBlYmI0ODEwN2IzOGQ2OTNj
NGM2NjczCgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpkb2Mvc3JjL3NnbWwveGZ1bmMu
c2dtbCAgICAgICAgICAgICAgICAgIHwgIDQ0ICsrLQpzcmMvYmFja2VuZC9jYXRhbG9nL3BnX3By
b2MuYyAgICAgICAgICAgIHwgIDExICstCnNyYy9iYWNrZW5kL2V4ZWN1dG9yL2Z1bmN0aW9ucy5j
ICAgICAgICAgfCA1MDggKysrKysrKysrKysrKysrKysrLS0tLS0tLS0tLS0tLQpzcmMvYmFja2Vu
ZC9vcHRpbWl6ZXIvdXRpbC9jbGF1c2VzLmMgICAgIHwgMTMxICsrKy0tLS0tCnNyYy9pbmNsdWRl
L2V4ZWN1dG9yL2Z1bmN0aW9ucy5oICAgICAgICAgfCAgIDggKy0Kc3JjL3Rlc3QvcmVncmVzcy9l
eHBlY3RlZC9yYW5nZWZ1bmNzLm91dCB8IDIxMCArKysrKysrKysrKystCnNyYy90ZXN0L3JlZ3Jl
c3Mvc3FsL3JhbmdlZnVuY3Muc3FsICAgICAgfCAgNzYgKysrKy0KNyBmaWxlcyBjaGFuZ2VkLCA2
NTYgaW5zZXJ0aW9ucygrKSwgMzMyIGRlbGV0aW9ucygtKQoK

--===============5698257757901136976==--