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 1tfJMB-001IRy-0M for pgsql-bugs@arkaria.postgresql.org; Tue, 04 Feb 2025 13:52:51 +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 1tfJMA-003Vpl-4B for pgsql-bugs@arkaria.postgresql.org; Tue, 04 Feb 2025 13:52:50 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tfIHh-003H3N-S4 for pgsql-bugs@lists.postgresql.org; Tue, 04 Feb 2025 12:44:10 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tfIHe-003ETs-1J for pgsql-bugs@lists.postgresql.org; Tue, 04 Feb 2025 12:44:09 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=xRVfBB1+qtZ7sHVGL8pYkr0CLKKZQ4JDydLl65qDASU=; b=MZ7P+5HkOQcW43GOFXHK5WTymd R5l+k7LaEBOgXGvsojToQZ3VX/aLTyojzBf9cnw5+3NPjNS2HTJIPEPLZ9jZLNksm+o45HVnCitUm tHa9FHOcbHLReaNH4/+NztU1cKTAR2bW7uoTZzvbHbnzXpZ1r625Ug3OtBxWVB+FgxET5w7tB+WFJ T2QcWPKPEs7Xm8lN+2XgXdTVIfwXRMcR3YmEHQ4Z746RDCkGWBQaNj9dzFSNf14i7DPEMu5eL2v9e XkupTz3EQ4E1mhoLaWzbuo0dblJWKxcWGIZxc6yeVaTe8Mc8Pi0ykPadVva9xIbnDw5ChQYUHhx9L c8FneOOw==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tfIHc-00FhIe-Lt for pgsql-bugs@lists.postgresql.org; Tue, 04 Feb 2025 12:44:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tfIHb-00FhLD-2N for pgsql-bugs@lists.postgresql.org; Tue, 04 Feb 2025 12:44:02 +0000 Content-Type: multipart/mixed; boundary="===============0986747321069511100==" MIME-Version: 1.0 Subject: BUG #18793: PLpgSQL Function Returning Type of Table is not match for varchar(n) data type via Return Query To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: ugurlu2001@hotmail.com Reply-To: ugurlu2001@hotmail.com, pgsql-bugs@lists.postgresql.org Date: Tue, 04 Feb 2025 12:43:25 +0000 Message-ID: <18793-07a72289887f0966@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============0986747321069511100== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODc5MwpMb2dnZWQgYnk6ICAgICAgICAgIFVndXIgWUlMTUFaCkVtYWls IGFkZHJlc3M6ICAgICAgdWd1cmx1MjAwMUBob3RtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246 IDE3LjIKT3BlcmF0aW5nIHN5c3RlbTogICBXaW5kb3dzIDExIFBybwpEZXNjcmlwdGlvbjogICAg ICAgIAoKSSBoYXZlIGEgc2V0IG9mICJGdW5jdGlvbnMiIHRoYXQgSSBjcmVhdGVkIGR5bmFtaWNh bGx5IHdpdGggUExQZ1NRTCBhbmQgYXJlCmNvbm5lY3RlZCB0byBlYWNoIG90aGVyIGluIGEgY2hh aW4uDQoNClRoZSBmaXJzdCBmdW5jdGlvbiBkeW5hbWljYWxseSBjcmVhdGVzIHRoZSBzZWNvbmQg ZnVuY3Rpb24uIFRoZSBzZWNvbmQKZnVuY3Rpb24gcmV0dXJucyBhIHNldCBvZiB2YWx1ZXMgd2l0 aCBhIGR5bmFtaWMgIlJldHVybiBRdWVyeSIgc3RhdGVtZW50IGFuZAphIHJlZmVyZW5jZSB0byAi UmV0dXJucyBUYWJsZSAoZmllbGQxIHR5cGUxLCBmaWVsZDIgdHlwZTIgLi4uLiApIi4NCg0KQmFz aWNhbGx5LCB0aGUgcmVzdWx0IHNldCBzZWVtcyB0byByZXR1cm4gZXhhY3RseSB0aGUgZGVzaXJl ZCByZXN1bHQuIFRoZQpleGNlcHRpb24gaXMgdGhlIHZhcmNoYXIobikgZml4ZWQtbGVuZ3RoIGRh dGEgdHlwZS4gQWx0aG91Z2ggdGhlIHJlc3VsdCBzZXQKaXMgZXhwZWN0ZWQgdG8gYmUgdmFyY2hh cihuKSAtYSBmaXhlZC1sZW5ndGggdmFsdWUgaXMgZXhwZWN0ZWQtLCBhIHJlc3VsdCBvZgp0eXBl IGNoYXJhY3RlciB2YXJ5aW5nIChsZW5ndGggaW5kZXRlcm1pbmF0ZSkgaXMgb2J0YWluZWQuDQoN CllvdSBjYW4gc2VlIHRoZSBkeW5hbWljYWxseSBjcmVhdGVkIGZ1bmN0aW9uIGV4YW1wbGUgdGhh dCBJIHVzZSBiZWxvdy4gSW4KYWRkaXRpb24gdG8gdGhlIHNhbXBsZSBmdW5jdGlvbiwgSSBhbSBh bHNvIHNoYXJpbmcgdGhlICJCYXNpYyBTUUwiIHNlbnRlbmNlCnRoYXQgcmV0dXJucyAiY2hhcmFj dGVyIHZhcnlpbmcgKGxlbmd0aCBpbmRldGVybWluYXRlKSIgZGF0YS4gSXQgYWxzbwpyZXR1cm5z IHRoZSBjb3JyZWN0IHJlc3VsdC4NCg0KSSBoYXZlIGJlZW4gdHJ5aW5nIHRvIHNvbHZlIHRoaXMg c2VlbWluZ2x5IHNpbXBsZSBwcm9ibGVtIGZvciBhIGZldyBkYXlzLgpIb3dldmVyLCBJIGhhdmUg YSBzcGVjaWFsIHJlc3RyaWN0aW9uIG9uIHRoZSBWYXJjaGFyKDI1NCkgbGltaXQgaW4gbXkKZGV2 ZWxvcG1lbnQgZW52aXJvbm1lbnQuDQoNCkNvcnJlY3RseSB3b3JraW5nIFNRTCBzY3JpcHQ6DQoN Ci0tIGtvZHggPiByZXR1cm5pbmcgY2hhcmFjdGVyIHZhcnlpbmcgOjogbGVuZ3RoIGluZGV0ZXJt aW5hdGUNCiBTRUxFQ1QgaWR4LGtvZHgsIGd1aWR4ICAgDQoJICxyb3VuZChoYXNfdG9wbGFtOjpu dW1lcmljLDIpIGFzIGhhcw0KCSxyb3VuZChndW11c190b3BsYW06Om51bWVyaWMsMikgYXMgZ3Vt dXMNCgkscm91bmQodXNkX3RvcGxhbTo6bnVtZXJpYywyKSBhcyB1c2QNCgkscm91bmQoZXVyX3Rv cGxhbTo6bnVtZXJpYywyKSBhcyBldXINCgkscm91bmQodHJsX3RvcGxhbTo6bnVtZXJpYywyKSBh cyB0cmwNCgkscm91bmQoZ2JwX3RvcGxhbTo6bnVtZXJpYywyKSBhcyBnYnANCgkscm91bmQoY2hm X3RvcGxhbTo6bnVtZXJpYywyKSBhcyBjaGYNCgkscm91bmQocGxhdGluX3RvcGxhbTo6bnVtZXJp YywyKSBhcyBwbGF0aW4NCgkscm91bmQoYWxsb3lfdG9wbGFtOjpudW1lcmljLDIpIGFzIGFsbG95 IA0KCSAgIEZST00gY3Jvc3N0YWIoJyANCgkJIFNFTEVDVCBpZHgsIGtvZHgsIGd1aWR4LCBidF9r b2QsIHRvcGxhbV9taWt0YXIgRlJPTSAgIA0KCQkgKCANCgkJIFNFTEVDVCBjbWEuY29tcGFueV9t YXN0ZXJfaWQgYXMgaWR4LCBidC5rb2QgQVMgYnRfa29kLCBidC5zeXNfZGVmYXVsdCwKU1VNKGNt YS5taWt0YXIpIGFzIHRvcGxhbV9taWt0YXIsIGNtLmtvZCBhcyBrb2R4LCBjbWEuY29tcGFueV9t YXN0ZXJfZ3VpZCBhcwpndWlkeCBGUk9NIGNvbXBhbnlfbWFzdGVyX2Ftb3VudHMgQVMgY21hICAN CgkJIAlMRUZUIE9VVEVSIEpPSU4gYmFsYW5jZV90eXBlcyBhcyBidCBPTiBjbWEuYmFsYW5jZV90 eXBlc19ndWlkID0gYnQuZ3VpZAoNCgkJIAlMRUZUIE9VVEVSIEpPSU4gY29tcGFueV9tYXN0ZXIg YXMgY20gT04gY20uaWQgPSBjbWEuY29tcGFueV9tYXN0ZXJfaWQgDQoJCSAJV0hFUkUgY29tcGFu eV9tYXN0ZXJfaWQgPSAzDQoJCSAJR1JPVVAgQlkgY21hLmNvbXBhbnlfbWFzdGVyX2lkLCBidC5r b2QsIGJ0LnN5c19kZWZhdWx0LCBjbS5rb2QsCmNtYS5jb21wYW55X21hc3Rlcl9ndWlkIA0KCQkg KSBPUkRFUiBCWSBpZHgsIHN5c19kZWZhdWx0IERFU0MsIGJ0X2tvZCANCgkJJzo6VEVYVCwgDQoJ CScgU0VMRUNUIGtvZCBhcyBrb2R4IEZST00gYmFsYW5jZV90eXBlcyBPUkRFUiBCWSBzeXNfZGVm YXVsdCBERVNDLCBrb2QsIGlkCic6OlRFWFQpIA0KCQljcm9zc3RhYihpZHggaW50ZWdlciwga29k eCBjaGFyYWN0ZXIgdmFyeWluZygyMDApLCBndWlkeCB1dWlkDQoJCQkJCSxoYXNfdG9wbGFtIG51 bWVyaWMoMjIsNiksZ3VtdXNfdG9wbGFtIG51bWVyaWMoMjIsNikNCgkJCQkJLHVzZF90b3BsYW0g bnVtZXJpYygyMiw2KSxldXJfdG9wbGFtIG51bWVyaWMoMjIsNikNCgkJCQkJLHRybF90b3BsYW0g bnVtZXJpYygyMiw2KSxnYnBfdG9wbGFtIG51bWVyaWMoMjIsNikNCgkJCQkJLGNoZl90b3BsYW0g bnVtZXJpYygyMiw2KSxwbGF0aW5fdG9wbGFtIG51bWVyaWMoMjIsNikNCgkJCQkJLGFsbG95X3Rv cGxhbSBudW1lcmljKDIyLDYpKQ0KIEdST1VQIEJZCmhhc190b3BsYW0sZ3VtdXNfdG9wbGFtLHVz ZF90b3BsYW0sZXVyX3RvcGxhbSx0cmxfdG9wbGFtLGdicF90b3BsYW0sY2hmX3RvcGxhbSxwbGF0 aW5fdG9wbGFtLGFsbG95X3RvcGxhbSxrb2R4LGd1aWR4LGlkeAoNCgkJICBPUkRFUiBCWSBrb2R4 OyANCgkJICANCg0KQSBmdW5jdGlvbiB0aGF0IHJldHVybnMgYSByZXN1bHQgb2YgaW5kZWZpbml0 ZSBsZW5ndGggaW4gdGhlIGZvcm0gb2YKImNoYXJhY3RlciB2YXJ5aW5nIiBpbnN0ZWFkIG9mICJD b2RlIDo6dmFyY2hhcigyMDApIi4gQSAiUmV0dXJucyBRdWVyeSIKZnVuY3Rpb24gdGhhdCBjcmVh dGVzIGEgZHluYW1pYyBTUUwgc2NyaXB0IGFuZCByZXR1cm5zIGEgdmFsdWUgaW4gdGhlICJUYWJs ZQpUeXBlIiAoc2Vjb25kIGxldmVsIC0gbmVlZGVkIGJ5IHRoZSBlbmQgdXNlcik6DQoNCg0KLS0g a29keCAoIGZpZWxkIG5hbWUga29kIG9uICJyZXR1cm4gdGFibGUiICkgPiByZXR1cm5pbmcgY2hh cmFjdGVyIHZhcnlpbmcKKDIwMCkNCi8qIA0KRlVOQ1RJT046IHB1YmxpYy5nZXRfYmFsYW5jZV9w aXZvdF8xYyhpbnRlZ2VyKQ0KRFJPUCBGVU5DVElPTiBJRiBFWElTVFMgcHVibGljLmdldF9iYWxh bmNlX3Bpdm90XzFjKGludGVnZXIpOw0KU2VsZWN0ICogZnJvbSBnZXRfYmFsYW5jZV9waXZvdF8x YygzKSA7IA0KKi8gDQpDUkVBVEUgT1IgUkVQTEFDRSBGVU5DVElPTiBwdWJsaWMuZ2V0X2JhbGFu Y2VfcGl2b3RfMWMoDQoJcGludGNvbXBhbnlfaWQgaW50ZWdlcikNCiAgICBSRVRVUk5TIFRBQkxF KGlkIGludGVnZXIsIGtvZCB2YXJjaGFyKDIwMCksIGd1aWQgdXVpZCwgaGFzIG51bWVyaWMsCmd1 bXVzIG51bWVyaWMsIHVzZCBudW1lcmljLCBldXIgbnVtZXJpYywgdHJsIG51bWVyaWMsIGdicCBu dW1lcmljLCBjaGYKbnVtZXJpYywgcGxhdGluIG51bWVyaWMsIGFsbG95IG51bWVyaWMpIA0KICAg IExBTkdVQUdFICdwbHBnc3FsJw0KICAgIENPU1QgMTAwDQoJU1RBQkxFIFBBUkFMTEVMIFNBRkUN CiAgICBST1dTIDEwMDAgDQoNCkFTICRCT0RZJCANCiBCRUdJTiANCiBSRVRVUk4gUVVFUlkgDQoN CiBTRUxFQ1QgaWR4LGtvZHg6OnZhcmNoYXIoMjAwKSwgZ3VpZHggICANCgkgLHJvdW5kKGhhc190 b3BsYW06Om51bWVyaWMsMikgYXMgaGFzDQoJLHJvdW5kKGd1bXVzX3RvcGxhbTo6bnVtZXJpYywy KSBhcyBndW11cw0KCSxyb3VuZCh1c2RfdG9wbGFtOjpudW1lcmljLDIpIGFzIHVzZA0KCSxyb3Vu ZChldXJfdG9wbGFtOjpudW1lcmljLDIpIGFzIGV1cg0KCSxyb3VuZCh0cmxfdG9wbGFtOjpudW1l cmljLDIpIGFzIHRybA0KCSxyb3VuZChnYnBfdG9wbGFtOjpudW1lcmljLDIpIGFzIGdicA0KCSxy b3VuZChjaGZfdG9wbGFtOjpudW1lcmljLDIpIGFzIGNoZg0KCSxyb3VuZChwbGF0aW5fdG9wbGFt OjpudW1lcmljLDIpIGFzIHBsYXRpbg0KCSxyb3VuZChhbGxveV90b3BsYW06Om51bWVyaWMsMikg YXMgYWxsb3kgDQoJICAgRlJPTSBjcm9zc3RhYignIA0KCQkgU0VMRUNUIGlkeCwga29keCwgZ3Vp ZHgsIGJ0X2tvZCwgdG9wbGFtX21pa3RhciBGUk9NICAgDQoJCSAoIA0KCQkgU0VMRUNUIGNtYS5j b21wYW55X21hc3Rlcl9pZCBhcyBpZHgsIGJ0LmtvZCBBUyBidF9rb2QsIGJ0LnN5c19kZWZhdWx0 LApTVU0oY21hLm1pa3RhcikgYXMgdG9wbGFtX21pa3RhciwgY20ua29kIGFzIGtvZHgsIGNtYS5j b21wYW55X21hc3Rlcl9ndWlkIGFzCmd1aWR4IEZST00gY29tcGFueV9tYXN0ZXJfYW1vdW50cyBB UyBjbWEgIA0KCQkgCUxFRlQgT1VURVIgSk9JTiBiYWxhbmNlX3R5cGVzIGFzIGJ0IE9OIGNtYS5i YWxhbmNlX3R5cGVzX2d1aWQgPSBidC5ndWlkCg0KCQkgCUxFRlQgT1VURVIgSk9JTiBjb21wYW55 X21hc3RlciBhcyBjbSBPTiBjbS5pZCA9IGNtYS5jb21wYW55X21hc3Rlcl9pZCANCgkJIAlXSEVS RSBjb21wYW55X21hc3Rlcl9pZCA9IDMNCgkJIAlHUk9VUCBCWSBjbWEuY29tcGFueV9tYXN0ZXJf aWQsIGJ0LmtvZCwgYnQuc3lzX2RlZmF1bHQsIGNtLmtvZCwKY21hLmNvbXBhbnlfbWFzdGVyX2d1 aWQgDQoJCSApIE9SREVSIEJZIGlkeCwgc3lzX2RlZmF1bHQgREVTQywgYnRfa29kIA0KCQknOjpU RVhULCANCgkJJyBTRUxFQ1Qga29kIGFzIGtvZHggRlJPTSBiYWxhbmNlX3R5cGVzIE9SREVSIEJZ IHN5c19kZWZhdWx0IERFU0MsIGtvZCwgaWQKJzo6VEVYVCkgY3Jvc3N0YWIoaWR4IGludGVnZXIs IGtvZHggY2hhcmFjdGVyIHZhcnlpbmcoMjAwKSwgZ3VpZHggdXVpZCwKaGFzX3RvcGxhbSBudW1l cmljKDIyLDYpLGd1bXVzX3RvcGxhbSBudW1lcmljKDIyLDYpLHVzZF90b3BsYW0KbnVtZXJpYygy Miw2KSxldXJfdG9wbGFtIG51bWVyaWMoMjIsNiksdHJsX3RvcGxhbSBudW1lcmljKDIyLDYpLGdi cF90b3BsYW0KbnVtZXJpYygyMiw2KSxjaGZfdG9wbGFtIG51bWVyaWMoMjIsNikscGxhdGluX3Rv cGxhbQpudW1lcmljKDIyLDYpLGFsbG95X3RvcGxhbSBudW1lcmljKDIyLDYpKQ0KIEdST1VQIEJZ Cmhhc190b3BsYW0sZ3VtdXNfdG9wbGFtLHVzZF90b3BsYW0sZXVyX3RvcGxhbSx0cmxfdG9wbGFt LGdicF90b3BsYW0sY2hmX3RvcGxhbSxwbGF0aW5fdG9wbGFtLGFsbG95X3RvcGxhbSxrb2R4LGd1 aWR4LGlkeAoNCgkJICBPUkRFUiBCWSBrb2R4OyANCgkvKiBXSEVSRSBjb21wYW55X21hc3Rlcl9p ZCA9ICcgfHwgcGludGNvbXBhbnlfaWQgfHwgJyAqLyANCgkvKiBXSEVSRSBjb21wYW55X21hc3Rl cl9pZCA9ICcgfHwgJzMnIHx8ICcgKi8gDQoNCiAgRU5EIDsgDQogDQokQk9EWSQ7DQoNCkFMVEVS IEZVTkNUSU9OIHB1YmxpYy5nZXRfYmFsYW5jZV9waXZvdF8xYyhpbnRlZ2VyKQ0KICAgIE9XTkVS IFRPIHBvc3RncmVzOw0KDQoNCg0KQXMgZmFyIGFzIEkgaGF2ZSBkZXRlcm1pbmVkLCB0aGUgUG9z dGdyZXNxbCBkYXRhYmFzZSBlbmdpbmUgc29tZWhvdyByZXR1cm5zCnRoZSB2YXJjaGFyKG4pIC0g Rml4ZWQgTGVuZ3RoIC0gZGF0YSB0eXBlIGFzIGEgImNoYXJhY3RlciB2YXJ5aW5nIiAtCmluZGVm aW5pdGUgbGVuZ3RoIGRhdGEgdHlwZS4NCg0KSSBob3BlIHRoaXMgc2l0dWF0aW9uLCB3aGljaCBJ IG9ic2VydmVkIGFzIGEgcHJvYmxlbSwgd2lsbCBiZSBmaXhlZCBhcyBzb29uCmFzIHBvc3NpYmxl Lg0KDQpCZXN0IHdpc2hlcy4uLgoK --===============0986747321069511100==--