Re: Working around insert into a_table from select things from a_function

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: pgsql-sql(at)lists(dot)postgresql(dot)org
Subject: Re: Working around insert into a_table from select things from a_function
Date: 2023-07-04 23:28:42
Message-ID: b29d8a15-f898-d135-a0cf-299747cb1889@gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Shaozhong SHI 2023-07-06 15:46:55 How to select the last value/row?
Previous Message Rob Sargent 2023-07-04 23:27:52 Re: How come column is locked?