Postgres Pro
Downloads
Home   >   mailing lists

Re: Working around insert into a_table from select things from a_function - Mailing list pgsql-sql

From Rob Sargent
Subject Re: Working around insert into a_table from select things from a_function
Date
Msg-id b29d8a15-f898-d135-a0cf-299747cb1889@gmail.com
Whole thread Raw
In response to Working around insert into a_table from select things from a_function  (Shaozhong SHI <shishaozhong@gmail.com>)
List pgsql-sql
Tree view
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

pgsql-sql by date:

Previous
From: Rob Sargent
Date:
Subject: Re: How come column is locked?
Next
From: Shaozhong SHI
Date:
Subject: How to select the last value/row?