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 1qGjXH-0002rT-SV for pgsql-sql@arkaria.postgresql.org; Tue, 04 Jul 2023 17:09:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qGjXG-0005ik-1g for pgsql-sql@arkaria.postgresql.org; Tue, 04 Jul 2023 17:09:54 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qGjXF-0005ia-PK for pgsql-sql@lists.postgresql.org; Tue, 04 Jul 2023 17:09:53 +0000 Received: from mout.gmx.net ([212.227.15.18]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qGjX8-0021P6-LX for pgsql-sql@lists.postgresql.org; Tue, 04 Jul 2023 17:09:52 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=s31663417; t=1688490583; x=1689095383; i=karsten.hilbert@gmx.net; bh=uEz05u16cWa+U73owp+D/xpNb1qVBFA05gWn/xp9ZyY=; h=X-UI-Sender-Class:From:Cc:Subject:Date:In-Reply-To:References; b=QlNmXFiFy3Wo1sW5Ozc6s+qV2rougwui2yeNkiMFnLl17eBs4ztfc7r3rkf3GE/w3KhJarP /l3SxjQSdQEZysAmQLwo1lJ33bM45ybIvWbX3nnlFgZbeF4HEwD7GFs6nep5DBOP9qT8KbO5x IJIX6TSXjkTvzqF8zvPTirA/2QlHSy/qB1moMrqbSFcALnphBwIGcz1NmGYzIa5HKTqkRURRY CP+Dw9VjfYbqGdHYhClfcd2oLAVauBPHxqeP1L6zxz8eU8m1Tu7d9OjqNdx0XeTXSJ4OXXLSc sXnvFotvGXWbgalGqgGGy4K0Hx7xPunnTlvNFf3aMIeA6d/IKwTA== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from [217.91.207.107] ([217.91.207.107]) by web-mail.gmx.net (3c-app-gmx-bs48.server.lan [172.19.170.101]) (via HTTP); Tue, 4 Jul 2023 19:09:43 +0200 MIME-Version: 1.0 Message-ID: From: Karsten Hilbert Cc: pgsql-sql Subject: Aw: Working around insert into a_table from select things from a_function Content-Type: text/plain; charset=UTF-8 Date: Tue, 4 Jul 2023 19:09:43 +0200 Importance: normal Sensitivity: Normal In-Reply-To: References: Content-Transfer-Encoding: quoted-printable X-UI-Message-Type: mail X-Priority: 3 X-Provags-ID: V03:K1:wvU0zD47BDdbyRiCqy7OuIUG4j2o/mh1ntOosHstzYRhCaPSmxnQMxhEOkKyeeGeerlMg vcMeSUSBHHv9g7w+kjXPi/N90PYb1o6/Yds4VPcnHLSASypzKX9FYBoUdkWu1QFB0m11IPAwXWK0 4VxwAFdul5af91y38PhyUQWUUGr0ECSexW7IfpEg9qTOuFksC6ufjoXbUGIeOlfs5HREoN1nKIsF Ls/nftTK6+ihytYww2bkhqZgs2OvuJiwvo3HzrxwwqnICw/Ykwua+0YMyZyt1/W2NESOs533gF4p HQ= X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:6GmxmqvgU/E=;+L+QeRr/3HkHaj83QO+5/UDsEkx YdHs0ftHqHTo8lkPkaLiDhED7YsLmwoyN4dSblBm4Yp7nAdUzj45oEw3njnXbBHI28U6eLaUh 0L29FCOvDLk7lc+OyaYxgWa9ebTbMTZaX+fbAZH1ssG2Lg3IAwPrnhqNZrRIktSq3h742c1qB YatiGsV9H4fthDGBAGY0Stq8MEXfh0fOBEcKhu0muXcK4+jf3PqiNrQOjgg/BjLhW4dl5guCD RzxQ7q+c9kPndbhsPVfPNVf/ECEbVoUSa+tN2WoA6/MpPITl6zPcbigUeC8y+Ssb9Pq9RT2Dc Eynah3lXeyaotLNTpIVoSMl40Z/+ky90IxWvm4/cgRX2YqqrqeejJ9vBGsugaZAAOeYUEMarf mplP1H6mevFXE67IUZfdNJQYPPlQuX/yIP/I3bP6K+oO4QjKCl77n4edTS3x5e4G0bVPNBIp1 /2AeIeGWqYQEIN22EcHhMYKpnhg4SA9n7CQWycO2813XhjpiDJgfvXvMRoOEfteeapLBCOnaL QLi+HZBcqGdNpnlWj0vbkUWCCr7q7nnmIVzxtkgAWKI5QnzEEjokSBdSMJz8uhoEUcg1x0tMF 36ryZ+ucK9VX4y7F0OWt5h0ppk+7j+cvi6G8TfvgK77yKoQIG3f4Fmc+f+UqGbq1MaB6i5nBZ qnmYjResGUGtp1I2v3Wm4AWrO6e7D83sdHyjiBLc0muhwBmQ1gm1EpOpYDzud0Kt1w0lNjFzY pe+uceqZQTD9Z5sU6Na44A+xGBvH9+p6x4BuMyfTjJz6WuXsoZRJNiHHW+YT8wxIfKtIBFGoq M7PA2gfSrES3MX96mB2Qiwow== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Von:=C2=A0"Shaozhong SHI" > >I can manually select columns from a_function=2E >=C2=A0 >But, when in a loop in a do statement, it does not work=2E >=C2=A0 >These columns are of array type=2E >=C2=A0 >Can anyone shed light on this? Sure=2E You yourself=2E By providing relevant detail=2E It seems rather unthoughtful to have people second-guess your environment= =2E Best, Karsten