Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1k5RzE-0004dG-A6 for pgsql-sql@arkaria.postgresql.org; Tue, 11 Aug 2020 10:58:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1k5RzC-0008Rq-Su for pgsql-sql@arkaria.postgresql.org; Tue, 11 Aug 2020 10:58:30 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1k5RzC-0008Ri-L9 for pgsql-sql@lists.postgresql.org; Tue, 11 Aug 2020 10:58:30 +0000 Received: from forward501p.mail.yandex.net ([2a02:6b8:0:1472:2741:0:8b7:120]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1k5Rz5-0004fm-F7 for pgsql-sql@lists.postgresql.org; Tue, 11 Aug 2020 10:58:30 +0000 Received: from mxback8g.mail.yandex.net (mxback8g.mail.yandex.net [IPv6:2a02:6b8:0:1472:2741:0:8b7:169]) by forward501p.mail.yandex.net (Yandex) with ESMTP id 53302350035A; Tue, 11 Aug 2020 13:58:21 +0300 (MSK) Received: from localhost (localhost [::1]) by mxback8g.mail.yandex.net (mxback/Yandex) with ESMTP id A1Tx7fsyRu-wK3q74Bj; Tue, 11 Aug 2020 13:58:20 +0300 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=reddoc.net; s=mail; t=1597143500; bh=PjDqZtQTfSiF2rI1q6J/fMMZlr0w4p2tb2uJVKR6Bew=; h=References:Date:Message-Id:Subject:In-Reply-To:To:From; b=ELsEoUJDwbqL/dUCFijJHF0pEN2lwp0mBHCiAZO3WQguafS3fXJwr9l7uhgEWUXNx 4pTOuv8zSBnzjQhAcLG09K5JTT4RLRLOL45pmEMRpok3kGHcgYMwCAN8ujJUeda1Rw 5M4aJRvuO+NMFJH3flJ8ij0vY6Cl2MGbZ8q3o8hU= Authentication-Results: mxback8g.mail.yandex.net; dkim=pass header.i=@reddoc.net Received: by myt5-bc0f9d8e5f27.qloud-c.yandex.net with HTTP; Tue, 11 Aug 2020 13:58:20 +0300 From: Samed YILDIRIM To: Mike Martin , pgsql-sql In-Reply-To: References: Subject: Re: Use multidimensional array as VALUES clause in insert MIME-Version: 1.0 X-Mailer: Yamail [ http://yandex.ru ] 5.0 Date: Tue, 11 Aug 2020 13:58:20 +0300 Message-Id: <917941597143282@mail.yandex.com.tr> Content-Transfer-Encoding: base64 Content-Type: text/html; charset=utf-8 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk PGRpdj5IaSBNaWtlLDwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PklmIHlvdSBzaGFyZSBzYW1wbGUg ZGF0YSwgZXhwZWN0ZWQgcmVzdWx0cywgdGFibGUgZGVmaW5pdGlvbnMgZXRjLCB3ZSBjYW4gaGVs cCB5b3UgZWFzaWVyLjwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PkJlc3QgcmVnYXJkcy48L2Rpdj48 ZGl2PjxiciAvPjwvZGl2PjxkaXY+PGJyIC8+PC9kaXY+PGRpdj7EsHlpIMOnYWzEscWfbWFsYXIu PC9kaXY+PGRpdj5TYW1lZCBZSUxESVJJTTwvZGl2PjxkaXY+PGJyIC8+PC9kaXY+PGRpdj48YnIg Lz48L2Rpdj48ZGl2PjxiciAvPjwvZGl2PjxkaXY+MTEuMDguMjAyMCwgMTM6NTAsICJNaWtlIE1h cnRpbiIgJmx0O3JlZHR1eDFAZ21haWwuY29tJmd0Ozo8L2Rpdj48YmxvY2txdW90ZT48ZGl2IGRp cj0ibHRyIj48ZGl2IGNsYXNzPSIzN2Y5OWMwNWFkZjYxY2VlZGUxMDA0ZWNlMmY0OWNlNWdtYWls LWFkbiAxNjlkMWU5NzhjNWM0ZDRkNmE3NWE2YjdjMjE4YzY3NmdtYWlsLWFkcyI+PGRpdiBjbGFz cz0iNjUwZWZhODBmNzVkYjBiMjE5NWZkY2M0OTIzYWZjNThnbWFpbC1ncyI+PGRpdiBjbGFzcz0i YmI1ZDg5MTcxZWQ3ODc3ODk3YzlhMjcyZTlkNzhjNWFnbWFpbC0iPjxkaXYgY2xhc3M9IjFlYzc3 NmJiMmM2MGYzMWNmM2I3N2ZiNTA4YTE0ZDBnbWFpbC1paSAxMTIxNmFlMzU5MGU2ZGQ1ZDQzNzk2 ZDlmZDk5Mjg3NWdtYWlsLWd0IiBpZD0iN2FiMGMwMmJjY2Q3OWQ3MWVmNTljMmRiZDlhNDhkNTZn bWFpbC06M2Y0Ij48ZGl2IGNsYXNzPSJkOTA5MzRjZTdkZWUxYTg1ZWIzODQwMjFhYzZkNjYxZ21h aWwtYTNzIDJmYmQ5OGNjMzNjNDJkMzM4MjJkYjdjNTIyMDhkYmVhZ21haWwtYVhqQ0giIGlkPSI4 ODAyZGVkOGU5NjhhMzgzZGViMGVlOWIyMGMzMTIxZmdtYWlsLTozZjMiPjxkaXYgZGlyPSJsdHIi PjxkaXY+SXMKIHRoaXMgcG9zc2libGU/IEkgaGF2ZSBzZWVuIGV4YW1wbGVzIHdpdGggYXJyYXkg bGl0ZXJhbHMgYXMgVkFMVUVTIApzdHJpbmcsIGJ1dCBJIGNhbnQgc2VlbiB0byBnZXQgaXQgdG8g d29yayB3aXRoIGFuIGFjdHVhbCBhcnJheS48L2Rpdj48ZGl2PjxiciAvPjwvZGl2PjxkaXY+dGVz dGluZyBjb2RlPC9kaXY+PGRpdj48YnIgLz48L2Rpdj48ZGl2Pi0tVGhpcyBnZXRzIG1lIGEgbXVs dGlkaW1lbnNpb25hbCBhcnJheTwvZGl2PjxkaXY+d2l0aCBhcnIgQVMgKDxiciAvPlNFTEVDVCBB UlJBWShTRUxFQ1QgQVJSQVlbZmlsZWlkOjp0ZXh0LHRhZ25hbWUsYXJyYXlfdG9fc3RyaW5nKHRh Z3ZhbHVlLEUnXGInKV0gPGJyIC8+CUZST00gdGFnZGF0YV9hbGwpIC0tIGxpbWl0IDEwMCk8YnIg Lz4JYXJyMTxiciAvPik8YnIgLz48L2Rpdj48ZGl2Pi0tVGhlbiA8YnIgLz48L2Rpdj48ZGl2Pjxi ciAvPjwvZGl2PjxkaXY+SU5TRVJUIElOVE/CoCB0YWdkYXRhdGVzdDI8YnIgLz5TRUxFQ1QgwqBh cnIxOjp0ZXh0W10gRlJPTSBhcnIgLS1kb2VzbnQgd29yayBvbmx5IHBvcHVsYXRlcyBvbmUgY29s dW1uIHdpdGggb3JpZ2luYWwgYXJyYXk8L2Rpdj48ZGl2IGNsYXNzPSIzZWI0YmRjYjQxYzdhYjkx ZmQyZDA0NTAzNzFlMGQxZmdtYWlsLWFkTCI+PGJyIC8+PC9kaXY+PC9kaXY+PGRpdiBjbGFzcz0i M2ViNGJkY2I0MWM3YWI5MWZkMmQwNDUwMzcxZTBkMWZnbWFpbC1hZEwiPgo8L2Rpdj48L2Rpdj48 L2Rpdj48L2Rpdj48L2Rpdj48L2Rpdj48ZGl2IGNsYXNzPSI2MWM5ODMxZDk1ODVjN2ExODQ0M2U5 NmU2NDI5YzA2ZWdtYWlsLWdBIDExMjE2YWUzNTkwZTZkZDVkNDM3OTZkOWZkOTkyODc1Z21haWwt Z3QgYzM5NTIzOTQxZmI4Y2VjZjAzODIzYmU1NGRiNDc1MmdtYWlsLWFjViI+PGRpdiBjbGFzcz0i ZTEwMmRlY2JiZWI4OTEwN2JlYzZmN2Y2ZmM4MDEzMmJnbWFpbC1nQiA2MWM5MTNhMGUzZTdkNjI2 MTlkZmExYWEyNzRkOWMzOWdtYWlsLXh1Ij48ZGl2IGNsYXNzPSJlNmM5YjZjYWNjOWI5ZmU1NzAy NGYyZGMxNmE3ZjEyYmdtYWlsLWlwIDc5NjVlNDIyMjMxMjM4OTE3ZmRiZmM5Mjc1NDMwZGM4Z21h aWwtaXEiPjxkaXYgaWQ9IjFlZDI4NmEwMjZkZjgyODllMzEwZWIzMTFlMWY4ZjlnbWFpbC06M2Y1 Ij48dGFibGUgY2xhc3M9ImY3YmNlMGNhNjkzNjdkZGI2ZDhlNmQ1OGM1M2U2MTYzZ21haWwtY2Yg MjRkNTE5ZDhlMzFiNjkxYmEyMWI5NDQ4Yjk2OGM0MjhnbWFpbC13UyI+PHRib2R5Pjx0cj48dGQg Y2xhc3M9IjdlNWY4ZWM5YTFiODJlMzQ1OGQ4NGRiMzliNGYzZmRnbWFpbC1hbXEiPjxpbWcgY2xh c3M9ImQzMzE1ODIyMzY2Nzk1YmVmNjVlNGQzYzBjOGJiYmJmZ21haWwtYWpuIGM0MWYzMmFhNzhk NTkzNTJjNjA1MzIyMjk5ODNhMWZnbWFpbC1ib2ZQZ2UiIGlkPSI2MjZhNmQwN2UzN2MxOTMwNGIz MjQzZDkyNDZmNzNhMGdtYWlsLToxcV84MiIgc3JjPSJodHRwczovL3d3dy5nb29nbGUuY29tL3My L3UvMC9waG90b3MvcHVibGljL0FJYkVpQUlBQUFCRENQQ3BxZVRQbzdhUEh5SUxkbU5oY21SZmNH aHZkRzhxS0dRME1tUmxNR1ZpTVdRNFpEUXpOakF5WkRCaE5HWXlNV013T1RSa05HVmhaRFJrWkRr MU5qZ3dBYkR3VC10TTJQQWpaekMtNVFkNUJDQzhPay1yP3N6PTQwIiAvPjwvdGQ+PHRkIGNsYXNz PSI1YzY4NzQ1MDJiNjg3ZTViM2RiNmFiM2Y0ODYxNzE1NGdtYWlsLWFtciI+PGJyIC8+PC90ZD48 L3RyPjwvdGJvZHk+PC90YWJsZT48L2Rpdj48L2Rpdj48L2Rpdj48L2Rpdj48L2Rpdj4KPC9ibG9j a3F1b3RlPg==