Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rfwvh-003Hig-TZ for pgsql-bugs@arkaria.postgresql.org; Fri, 01 Mar 2024 07:03:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rfwvf-00C7RE-Js for pgsql-bugs@arkaria.postgresql.org; Fri, 01 Mar 2024 07:03:36 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rfoix-00967g-Id for pgsql-bugs@lists.postgresql.org; Thu, 29 Feb 2024 22:17:56 +0000 Received: from mx0a-000e5c01.pphosted.com ([67.231.149.193]) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rfoio-002DuM-Jo for pgsql-bugs@lists.postgresql.org; Thu, 29 Feb 2024 22:17:54 +0000 Received: from pps.filterd (m0072697.ppops.net [127.0.0.1]) by mx0b-000e5c01.pphosted.com (8.17.1.19/8.17.1.19) with ESMTP id 41TLxsWm004971; Thu, 29 Feb 2024 17:17:45 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=evernorth.com; h=from : to : cc : date : message-id : references : in-reply-to : content-type : content-transfer-encoding : mime-version : subject; s=pod011016231234; bh=nuKpx8QR9UuCJXmQm7D1h1qyE9pv0nU5P+5gjF2wlFk=; b=mbkVhrWkgi9b9IG7uWSNwGehEOZ+fgaQrvLh8JlvySwo8s+laJCiIiuBRkbDkOW2XQ90 rsAmEV0RLOXxf6nczM9kKt95VXp4A//+YsNvFsczVXGL3enLKxTxHOhL+f3AMckJgfuE k6sLNXQ0lncRnXNuZeucU4bc5SPBAL1Hdsjgtz6Dz2PzUHAzcr6CIkXV/6GTd5IrtEpM GgICGX2tTypvJEXCkE1oFxcRh9sifVCItPTcvUlyqndRhMeExW0vP+5YwHoO5u3bMg0O 7j18TJHzdkvsfQGf2y0CgmmNngZAsiKgL7m1hLGmZ3cTe+QoYodrSqy38XmrpmsUkIJO dg== Received: from express-scripts.com (mx0a-000e5c14.pphosted.com [148.163.133.209]) by mx0b-000e5c01.pphosted.com (PPS) with ESMTPS id 3wk2akg1kr-1 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NOT); Thu, 29 Feb 2024 17:17:45 -0500 Received: from m0206226.ppops.net (m0206226.ppops.net [127.0.0.1]) by pps.cigna (8.17.1.5/8.17.1.5) with ESMTP id 41TMHiVE025277; Thu, 29 Feb 2024 16:17:44 -0600 Received: from eiaappxp0012.gid.prd.globalcore.com (lyncav03.cigna.com [170.48.19.151]) by mx0a-000e5c14.pphosted.com (PPS) with ESMTPS id 3wjyvggdv9-4 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NOT); Thu, 29 Feb 2024 16:17:44 -0600 Received: from cvlappxp20750.internal.cigna.com (HELO PS2PW1012187.accounts.root.corp) ([10.36.52.82]) by EIAAPPXP0012.gid.prd.globalcore.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 29 Feb 2024 22:17:43 +0000 Received: from PS2PW1012186.accounts.root.corp (10.221.225.154) by PS2PW1012187.accounts.root.corp (10.221.225.157) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.2.1258.27; Thu, 29 Feb 2024 17:17:43 -0500 Received: from PS2PW1012186.accounts.root.corp ([fe80::9fec:fffb:1381:33ad]) by PS2PW1012186.accounts.root.corp ([fe80::9fec:fffb:1381:33ad%6]) with mapi id 15.02.1258.027; Thu, 29 Feb 2024 17:17:43 -0500 From: "Wetmore, Matthew (CTR)" To: PetSerAl , "David G. Johnston" CC: Tom Lane , "pgsql-bugs@lists.postgresql.org" Thread-Topic: [EXTERNAL] Re: Record returning function accept not matched columns declaration Thread-Index: AQHaa0hBr/wiEkf8ikCzyJI1pFaUpbEiFCiAgAAWcQCAAAhcgP//sBqw Date: Thu, 29 Feb 2024 22:17:42 +0000 Message-ID: <32d13003fc3c458a83f22c5024c2e295@evernorth.com> References: <2741768.1709237477@sss.pgh.pa.us> In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.221.252.1] x-proofpoint-routing: 000e5c14 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-CFilter-Loop: Reflected Subject: Record returning function accept not matched columns declaration X-Proofpoint-Virus-Version: vendor=baseguard engine=ICAP:2.0.272,Aquarius:18.0.1011,Hydra:6.0.619,FMLib:17.11.176.26 definitions=2024-02-29_06,2024-02-29_01,2023-05-22_02 X-Proofpoint-GUID: zffKLsMKm7duKusNnhKq2R5Rv8a_xqqN X-Proofpoint-ORIG-GUID: zffKLsMKm7duKusNnhKq2R5Rv8a_xqqN X-Connecting-IP: 148.163.133.209 X-External-Mail: True X-Content-Length: 8306 X-Proofpoint-Virus-Version: vendor=baseguard engine=ICAP:2.0.272,Aquarius:18.0.1011,Hydra:6.0.619,FMLib:17.11.176.26 definitions=2024-02-29_06,2024-02-29_01,2023-05-22_02 X-Proofpoint-Spam-Details: rule=notspam policy=default score=0 clxscore=1011 phishscore=0 mlxscore=0 bulkscore=0 adultscore=0 impostorscore=0 lowpriorityscore=0 priorityscore=1501 mlxlogscore=999 spamscore=0 suspectscore=0 malwarescore=0 classifier=spam adjust=0 reason=mlx scancount=1 engine=8.12.0-2311290000 definitions=main-2402290174 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk SSBoYWQgdGhpcyBpc3N1ZSBhcyB3ZWxsLg0KDQpUaGVyZSBpcyBtdWNoIGluZXQgdGFsayBhYm91 dCBhIGJ1ZyBpbiBQR2FkbWluIGluIGNyZWF0aW5nIGZ1bmN0aW9ucyB2IGNsaSwgYW5kIGhvdyBw Z0FkbWluIGRvZXNuJ3QgbGlrZSBzb21lIGZ1bmN0aW9ucy4NCg0KSSBoYWQgdG8gY2hhbmdlIG15 IGZ1bmN0aW9uIHRvIHRoaXMgbWV0aG9kIHRvIGdldCBvdXQgb2YgdGhlIGVycm9yLg0KDQpUaGUg ZXJyb3Igd2FudHMgeW91IHRvIGhhdmUgdGhlIGNvbHVtbnMgaW4gdGhlIGZ1bmN0aW9uLCBub3Qg YXQgU0VMRUNUIHN0YXRlbWVudC4NCg0KYXQgbGVhc3QgdGhpcyB3YXMgbXkgaXNzdWUsIHlvdXIg bWlsZWFnZSBtYXkgdmFyeS4NCg0KRFJPUCBGVU5DVElPTiBJRiBFWElTVFMgc2NoZW1hLmZ1bmN0 aW9uX25hbWU7DQoNCkNSRUFURSBPUiBSRVBMQUNFIEZVTkNUSU9OIHNjaGVtYS5mdW5jdGlvbl9u YW1lOygNCglfdHlwZWFoZWFkIGNoYXJhY3RlciB2YXJ5aW5nLA0KCV9yb2xlbmFtZSBjaGFyYWN0 ZXIgdmFyeWluZywNCglfcmVxdWlyZW1pc2NvbmR1Y3RhY2Nlc3MgY2hhcmFjdGVyIHZhcnlpbmcs DQoJX3Rlc3QxIGNoYXJhY3RlciB2YXJ5aW5nLA0KCV90ZXN0MiBjaGFyYWN0ZXIgdmFyeWluZywN CglfdGVzdDMgY2hhcmFjdGVyIHZhcnlpbmcpDQogICAgUkVUVVJOUyBUQUJMRShjb2wxIGNoYXJh Y3RlciB2YXJ5aW5nLCBjb2wyIGNoYXJhY3RlciB2YXJ5aW5nLCBjb2wzIGNoYXJhY3RlciB2YXJ5 aW5nKQ0KICAgIExBTkdVQUdFICdwbHBnc3FsJw0KICAgIENPU1QgMTAwDQogICAgVk9MQVRJTEUg UEFSQUxMRUwgVU5TQUZFDQogICAgUk9XUyAxMDAwDQoNCkFTICRCT0RZJA0KQkVHSU4NCg0KDQoN Ci0tLS0tT3JpZ2luYWwgTWVzc2FnZS0tLS0tDQpGcm9tOiBQZXRTZXJBbCA8cGV0c2VyYWxAZ21h aWwuY29tPiANClNlbnQ6IFRodXJzZGF5LCBGZWJydWFyeSAyOSwgMjAyNCAyOjAyIFBNDQpUbzog RGF2aWQgRy4gSm9obnN0b24gPGRhdmlkLmcuam9obnN0b25AZ21haWwuY29tPg0KQ2M6IFRvbSBM YW5lIDx0Z2xAc3NzLnBnaC5wYS51cz47IHBnc3FsLWJ1Z3NAbGlzdHMucG9zdGdyZXNxbC5vcmcN ClN1YmplY3Q6IFtFWFRFUk5BTF0gUmU6IFJlY29yZCByZXR1cm5pbmcgZnVuY3Rpb24gYWNjZXB0 IG5vdCBtYXRjaGVkIGNvbHVtbnMgZGVjbGFyYXRpb24NCg0KcG9zdGdyZXM9IyB3aXRoIGEoYikg YXMgKHZhbHVlcyAocm93KDEsMiwzKSkpIHBvc3RncmVzLSMgc2VsZWN0ICogZnJvbSBhLCBjb2Fs ZXNjZShiKTsNCkVSUk9SOiAgYSBjb2x1bW4gZGVmaW5pdGlvbiBsaXN0IGlzIHJlcXVpcmVkIGZv ciBmdW5jdGlvbnMgcmV0dXJuaW5nICJyZWNvcmQiDQpMSU5FIDI6IHNlbGVjdCAqIGZyb20gYSwg Y29hbGVzY2UoYik7DQogICAgICAgICAgICAgICAgICAgICAgICAgXg0KcG9zdGdyZXM9Iw0KcG9z dGdyZXM9IyB3aXRoIGEoYikgYXMgKHZhbHVlcyAocm93KDEsMiwzKSkpIHBvc3RncmVzLSMgc2Vs ZWN0ICogZnJvbSBhLCBudWxsaWYoYiwgbnVsbCk7DQpFUlJPUjogIGEgY29sdW1uIGRlZmluaXRp b24gbGlzdCBpcyByZXF1aXJlZCBmb3IgZnVuY3Rpb25zIHJldHVybmluZyAicmVjb3JkIg0KTElO RSAyOiBzZWxlY3QgKiBmcm9tIGEsIG51bGxpZihiLCBudWxsKTsNCiAgICAgICAgICAgICAgICAg ICAgICAgICBeDQpwb3N0Z3Jlcz0jDQpwb3N0Z3Jlcz0jIHdpdGggYShiKSBhcyAodmFsdWVzIChy b3coMSwyLDMpKSkgcG9zdGdyZXMtIyBzZWxlY3QgKiBmcm9tIGEsIHVubmVzdChhcnJheVtiXSk7 DQpFUlJPUjogIGEgY29sdW1uIGRlZmluaXRpb24gbGlzdCBpcyByZXF1aXJlZCBmb3IgZnVuY3Rp b25zIHJldHVybmluZyAicmVjb3JkIg0KTElORSAyOiBzZWxlY3QgKiBmcm9tIGEsIHVubmVzdChh cnJheVtiXSk7DQogICAgICAgICAgICAgICAgICAgICAgICAgXg0KcG9zdGdyZXM9Iw0KcG9zdGdy ZXM9IyB3aXRoIGEoYikgYXMgKHZhbHVlcyAocm93KDEsMiwzKSkpIHBvc3RncmVzLSMgc2VsZWN0 ICogZnJvbSBhLCBqc29uX3BvcHVsYXRlX3JlY29yZChiLCBudWxsKTsNCkVSUk9SOiAgYSBjb2x1 bW4gZGVmaW5pdGlvbiBsaXN0IGlzIHJlcXVpcmVkIGZvciBmdW5jdGlvbnMgcmV0dXJuaW5nICJy ZWNvcmQiDQpMSU5FIDI6IHNlbGVjdCAqIGZyb20gYSwganNvbl9wb3B1bGF0ZV9yZWNvcmQoYiwg bnVsbCk7DQogICAgICAgICAgICAgICAgICAgICAgICAgXg0KcG9zdGdyZXM9Iw0KDQpJdCBzZWVt cyBQb3N0Z3JlU1FMIGRvZXMgbm90IGNhcmUgYWJvdXQgZnVuY3Rpb24gYmVpbmcgcG9seW1vcnBo aWMsIGJ1dCBvbmx5IGFib3V0IHJldHVybiB0eXBlIGJlaW5nICJyZWNvcmQiLiBJdCBleHBsaWNp dGx5IHJlcXVpcmUgY29sdW1uIGRlZmluaXRpb24gbGlzdCBpbiBhbGwgdGhpcyBjYXNlcy4NCg0K 0L/RgiwgMSDQvNCw0YAuIDIwMjTigK/Qsy4g0LIgMDA6MzIsIERhdmlkIEcuIEpvaG5zdG9uIDxk YXZpZC5nLmpvaG5zdG9uQGdtYWlsLmNvbT46DQo+DQo+IE9uIFRodSwgRmViIDI5LCAyMDI0IGF0 IDE6MTHigK9QTSBUb20gTGFuZSA8dGdsQHNzcy5wZ2gucGEudXM+IHdyb3RlOg0KPj4NCj4+ICJE YXZpZCBHLiBKb2huc3RvbiIgPGRhdmlkLmcuam9obnN0b25AZ21haWwuY29tPiB3cml0ZXM6DQo+ PiA+IE9uIFRodXJzZGF5LCBGZWJydWFyeSAyOSwgMjAyNCwgUGV0U2VyQWwgPHBldHNlcmFsQGdt YWlsLmNvbT4gd3JvdGU6DQo+PiA+PiBwb3N0Z3Jlcz0jIHdpdGggYShiKSBhcyAodmFsdWVzIChy b3coMSwyLDMpKSkgcG9zdGdyZXMtIyBzZWxlY3QgKiANCj4+ID4+IGZyb20gYSwgY29hbGVzY2Uo YikgYXMgYyhkIGludCxlIGludCwgZiBpbnQpIHBvc3RncmVzLSMgdW5pb24gYWxsIA0KPj4gPj4g cG9zdGdyZXMtIyBzZWxlY3QgKiBmcm9tIGEsIG51bGxpZihiLCBudWxsKSBhcyBjKGQgaW50LGUg aW50LCBmIA0KPj4gPj4gaW50KSBwb3N0Z3Jlcy0jIHVuaW9uIGFsbCBwb3N0Z3Jlcy0jIHNlbGVj dCAqIGZyb20gYSwgDQo+PiA+PiB1bm5lc3QoYXJyYXlbYl0pIGFzIGMoZCBpbnQsZSBpbnQsIGYg aW50KSBwb3N0Z3Jlcy0jIHVuaW9uIGFsbCANCj4+ID4+IHBvc3RncmVzLSMgc2VsZWN0ICogZnJv bSBhLCBqc29uX3BvcHVsYXRlX3JlY29yZChiLCBudWxsKSBhcyBjKGQgDQo+PiA+PiBpbnQsZSBp bnQsIGYgaW50KTsgLS1leHBlY3QgT0sNCj4+DQo+PiA+IE15IGNvbmNlcm4gd2l0aCBhbGwgb2Yg dGhpcyBpcyBhY2NlcHRpbmcgdGhlIHNwZWNpZmljYXRpb24gb2YgDQo+PiA+IGNvbHVtbiBkZWZp bml0aW9ucyBmb3IgZnVuY3Rpb25zIHRoYXQgZG9u4oCZdCByZXR1cm4gdGhlIHJlY29yZCBwc2V1 ZG8tdHlwZS4NCj4+DQo+PiBIbT8gIFRoZXNlIGNhc2VzIGFsbCAqZG8qIHJldHVybiByZWNvcmQs IGJlY2F1c2UgdGhhdCdzIHdoYXQgYS5iIGlzIA0KPj4gdHlwZWQgYXMuDQo+DQo+DQo+IEkgc3Ry b25nbHkgZGlzbGlrZSB0aGUgc2VlbWluZ2x5IG92ZXJsb2FkZWQgdGVybWlub2xvZ3kgaW4gdGhp cyBhcmVhLiAgTmFtZWx5IEkgd2FzIHRyeWluZyB0byBkaXN0aW5ndWlzaCB0aGVzZSB0d28gZXhh bXBsZSBmdW5jdGlvbiBzaWduYXR1cmVzLg0KPg0KPiBqc29uX3BvcHVsYXRlX3JlY29yZCAoIGJh c2UgYW55ZWxlbWVudCwgZnJvbV9qc29uIGpzb24gKSDihpIgYW55ZWxlbWVudCANCj4ganNvbmJf dG9fcmVjb3JkICgganNvbmIgKSDihpIgcmVjb3JkDQo+DQo+IFBvbHltb3JwaGljIGZ1bmN0aW9u cyBkbyBub3QgcmVxdWlyZSBhIGNvbHVtbiBkZWZpbml0aW9uIGxpc3QuICBUaGUgbm9uLXBvbHlt b3JwaGljIGZ1bmN0aW9uIHNpZ25hdHVyZSBkb2VzIHJlcXVpcmUgdGhlIGNvbHVtbiBkZWZpbml0 aW9uIGxpc3QuICBUaGF0IHdlIGFjY2VwdCBhIGNvbHVtbiBkZWZpbml0aW9uIGxpc3QgaW4gdGhl IHBvbHltb3JwaGljIGNhc2UgaXMgc2V0dGxlZCBjb2RlIGJ1dCBzZWVtcyBsaWtlIGl0IGxlZCB0 byB0aGlzIGJ1Zy4NCj4NCj4gRGF2aWQgSi4NCg0KDQo=