Content-Type: multipart/alternative;
 boundary="------------btwT0lDHO6yvmPMKBtAKl700"
Message-ID: <b29d8a15-f898-d135-a0cf-299747cb1889@gmail.com>
Date: Tue, 4 Jul 2023 17:28:42 -0600
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101
 Thunderbird/102.11.0
Subject: Re: Working around insert into a_table from select things from
 a_function
Content-Language: en-CA
To: pgsql-sql@lists.postgresql.org
References: 
 <CA+i5JwbRD7fKQH8BBLbruqUc-RUg=mGFd3ZMdS+zKRsLOvZZcg@mail.gmail.com>
From: Rob Sargent <robjsargent@gmail.com>
In-Reply-To: 
 <CA+i5JwbRD7fKQH8BBLbruqUc-RUg=mGFd3ZMdS+zKRsLOvZZcg@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/b29d8a15-f898-d135-a0cf-299747cb1889%40gmail.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------btwT0lDHO6yvmPMKBtAKl700
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

On 7/4/23 10:58, Shaozhong SHI wrote:
> 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
show your select statement and full do loop

--------------btwT0lDHO6yvmPMKBtAKl700
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <div class="moz-cite-prefix">On 7/4/23 10:58, Shaozhong SHI wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:CA+i5JwbRD7fKQH8BBLbruqUc-RUg=mGFd3ZMdS+zKRsLOvZZcg@mail.gmail.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <div dir="ltr">I can manually select columns from a_function.
        <div><br>
        </div>
        <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>Can anyone shed light on this?</div>
        <div><br>
        </div>
        <div>Regards,</div>
        <div><br>
        </div>
        <div>David</div>
      </div>
    </blockquote>
    <font face="Courier New, Courier, monospace">show your select
      statement and full do loop<br>
      <br>
    </font>
  </body>
</html>

--------------btwT0lDHO6yvmPMKBtAKl700--