MIME-Version: 1.0
From: Shaozhong SHI <shishaozhong@gmail.com>
Date: Tue, 4 Jul 2023 17:58:58 +0100
Message-ID: 
 <CA+i5JwbRD7fKQH8BBLbruqUc-RUg=mGFd3ZMdS+zKRsLOvZZcg@mail.gmail.com>
Subject: Working around insert into a_table from select things from a_function
To: pgsql-sql <pgsql-sql@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000a62fae05ffac3332"
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2Bi5JwbRD7fKQH8BBLbruqUc-RUg%3DmGFd3ZMdS%2BzKRsLOvZZcg%40mail.gmail.com>
Precedence: bulk

--000000000000a62fae05ffac3332
Content-Type: text/plain; charset="UTF-8"

I can manually select columns from a_function.

But, when in a loop in a do statement, it does not work.

These columns are of array type.

Can anyone shed light on this?

Regards,

David

--000000000000a62fae05ffac3332
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">I can manually select columns from a_function.<div><br></d=
iv><div>But, when in a loop in a do statement, it does not work.</div><div>=
<br></div><div>These columns are of array type.</div><div><br></div><div>Ca=
n anyone shed light on this?</div><div><br></div><div>Regards,</div><div><b=
r></div><div>David</div></div>

--000000000000a62fae05ffac3332--